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 3438: FROM HR_LOCATIONS_ALL L

3434: (
3435: sel_ship_to_organization_id IS NOT NULL AND
3436: sel_ship_to_location_id IS NOT NULL AND
3437: NOT EXISTS (SELECT l.INVENTORY_ORGANIZATION_ID
3438: FROM HR_LOCATIONS_ALL L
3439: WHERE SYSDATE < NVL(L.INACTIVE_DATE, SYSDATE + 1) AND
3440: NVL(L.SHIP_TO_SITE_FLAG,'N') = 'Y' AND
3441: L.LOCATION_ID = sel_ship_to_location_id AND
3442: nvl (L.INVENTORY_ORGANIZATION_ID, sel_ship_to_organization_id) = sel_ship_to_organization_id)

Line 5440: FROM HR_LOCATIONS_ALL LOC,

5436: (
5437: SELECTED_SHIP_TO_LOCATION_ID IS NOT NULL AND
5438: SELECTED_SHIP_TO_LOCATION_ID NOT IN
5439: (SELECT LOC.LOCATION_ID
5440: FROM HR_LOCATIONS_ALL LOC,
5441: HR_ALL_ORGANIZATION_UNITS HAOU
5442: WHERE HAOU.ORGANIZATION_ID = SELECTED_ORG_ID AND
5443: NVL (LOC.BUSINESS_GROUP_ID, NVL(HAOU.BUSINESS_GROUP_ID, -99)) = NVL (HAOU.BUSINESS_GROUP_ID, -99) AND
5444: LOC.SHIP_TO_SITE_FLAG = 'Y' AND