eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_OTM_REF_DATA_GEN_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 88: FROM HR_ALL_ORGANIZATION_UNITS HOU,

84: ) RETURN NUMBER
85: IS
86: cursor l_stop_dd_org_csr(p_stop_id IN NUMBER) is
87: SELECT HOU.ORGANIZATION_ID
88: FROM HR_ALL_ORGANIZATION_UNITS HOU,
89: WSH_LOCATIONS WL,
90: WSH_NEW_DELIVERIES WND,
91: WSH_DELIVERY_LEGS WDL,
92: WSH_TRIP_STOPS WTS

Line 1447: HR_ALL_ORGANIZATION_UNITS ORG,

1443: GREATEST(HRL.LAST_UPDATE_DATE,
1444: nvl(ORG.LAST_UPDATE_DATE, to_date('1900/01/01 00:00:01', 'YYYY/MM/DD HH24:MI:SS'))
1445: ) LAST_UPDATE_DATE
1446: from HR_LOCATIONS_ALL HRL,
1447: HR_ALL_ORGANIZATION_UNITS ORG,
1448: --HR_ALL_ORGANIZATION_UNITS_TL ORGL,
1449: --FND_LANGUAGES FNDL,
1450: FND_TERRITORIES FNDTR,
1451: WSH_OTM_LOCATIONS_GTMP WLT, -- global temp table

Line 1448: --HR_ALL_ORGANIZATION_UNITS_TL ORGL,

1444: nvl(ORG.LAST_UPDATE_DATE, to_date('1900/01/01 00:00:01', 'YYYY/MM/DD HH24:MI:SS'))
1445: ) LAST_UPDATE_DATE
1446: from HR_LOCATIONS_ALL HRL,
1447: HR_ALL_ORGANIZATION_UNITS ORG,
1448: --HR_ALL_ORGANIZATION_UNITS_TL ORGL,
1449: --FND_LANGUAGES FNDL,
1450: FND_TERRITORIES FNDTR,
1451: WSH_OTM_LOCATIONS_GTMP WLT, -- global temp table
1452: MTL_PARAMETERS MP,