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.PON_NEGOTIATION_PUBLISH_PVT dependencies on HR_LOCATIONS_ALL

Line 2601: FROM HR_LOCATIONS_ALL L

2597: (
2598: sel_ship_to_organization_id IS NOT NULL AND
2599: sel_ship_to_location_id IS NOT NULL AND
2600: NOT EXISTS (SELECT l.INVENTORY_ORGANIZATION_ID
2601: FROM HR_LOCATIONS_ALL L
2602: WHERE SYSDATE < NVL(L.INACTIVE_DATE, SYSDATE + 1) AND
2603: NVL(L.SHIP_TO_SITE_FLAG,'N') = 'Y' AND
2604: L.LOCATION_ID = sel_ship_to_location_id AND
2605: nvl (L.INVENTORY_ORGANIZATION_ID, sel_ship_to_organization_id) = sel_ship_to_organization_id)

Line 4591: FROM HR_LOCATIONS_ALL LOC,

4587: (
4588: SELECTED_SHIP_TO_LOCATION_ID IS NOT NULL AND
4589: SELECTED_SHIP_TO_LOCATION_ID NOT IN
4590: (SELECT LOC.LOCATION_ID
4591: FROM HR_LOCATIONS_ALL LOC,
4592: HR_ALL_ORGANIZATION_UNITS HAOU
4593: WHERE HAOU.ORGANIZATION_ID = SELECTED_ORG_ID AND
4594: NVL (LOC.BUSINESS_GROUP_ID, NVL(HAOU.BUSINESS_GROUP_ID, -99)) = NVL (HAOU.BUSINESS_GROUP_ID, -99) AND
4595: LOC.SHIP_TO_SITE_FLAG = 'Y' AND