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_LOCATIONS_PKG dependencies on PO_LOCATION_ASSOCIATIONS_ALL

Line 545: PO_LOCATION_ASSOCIATIONS_ALL PLA

541: WSH.LONGITUDE,
542: NVL(HR.TIMEZONE_CODE, WSH.TIMEZONE_CODE),
543: SYSDATE
544: FROM WSH_LOCATIONS WSH, HR_LOCATIONS_ALL HR, HR_LOCATIONS_ALL_TL HRTL,
545: PO_LOCATION_ASSOCIATIONS_ALL PLA
546: WHERE SOURCE_LOCATION_ID between p_from_location and p_to_location
547: AND nvl(hr.last_update_date,sysdate) >= nvl(l_start_date, nvl(hr.last_update_date,sysdate))
548: AND nvl(hr.last_update_date,sysdate) < nvl(l_end_date, nvl(hr.last_update_date,sysdate)+1)
549: AND hr.location_id = wsh.source_location_id

Line 652: PO_LOCATION_ASSOCIATIONS_ALL PLA

648: NULL,
649: NULL,
650: HR.TIMEZONE_CODE
651: FROM HR_LOCATIONS_ALL HR, HR_LOCATIONS_ALL_TL HRTL,
652: PO_LOCATION_ASSOCIATIONS_ALL PLA
653: WHERE HR.LOCATION_ID between p_from_location and p_to_location
654: AND nvl(hr.last_update_date,sysdate) >= nvl(l_start_date, nvl(hr.last_update_date,sysdate))
655: AND nvl(hr.last_update_date,sysdate) < nvl(l_end_date, nvl(hr.last_update_date,sysdate)+1)
656: AND hr.location_id NOT IN ( select wl.source_location_id from wsh_locations wl

Line 2403: FROM PO_LOCATION_ASSOCIATIONS_ALL ploc,

2399: l_debug_on BOOLEAN;
2400: --
2401: CURSOR c_convert(p_int_cust_loc_id NUMBER,p_customer_id NUMBER) IS
2402: SELECT ploc.LOCATION_ID internal_org_location_id
2403: FROM PO_LOCATION_ASSOCIATIONS_ALL ploc,
2404: hz_cust_site_uses_all site_uses,
2405: hz_cust_acct_sites_all acct_sites,
2406: HZ_PARTY_SITES sites
2407: WHERE ploc.SITE_USE_ID = site_uses.SITE_USE_ID