-- OrgHierarchy Full Query
-- Source: JDESTAGE.F30006_VIEW
-- Destination: OrgHierarchy
-- Schedule: Mass/Daily/Hourly

SELECT TRIM(oh.DISPATCHGROUP_IWMCUW) AS ProfitCenterCode,
       TRIM(oh.COSTCENTER_IWMCU) AS WorkCenterCode,
       TRIM(oh.COSTCENTERALT_IWMMCU) AS BranchCode,
       oh.DATEUPDATED_IWUPMJ AS DateUpdated,
       oh.TIMEOFDAY_IWTDAY AS TimeUpdated
  FROM JDESTAGE.F30006_VIEW oh
 WHERE TRIM(oh.COSTCENTER_IWMCU) IS NOT NULL AND
       TRIM(oh.COSTCENTERALT_IWMMCU) IS NOT NULL