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_OPEN_INTERFACE_PVT dependencies on HR_LOCATIONS_ALL

Line 2882: FROM HR_LOCATIONS_ALL L

2878: WHEN ( sel_ship_to_organization_id IS NOT NULL
2879: AND sel_ship_to_location_id IS NOT NULL
2880: AND NOT EXISTS
2881: (SELECT l.INVENTORY_ORGANIZATION_ID
2882: FROM HR_LOCATIONS_ALL L
2883: WHERE SYSDATE < NVL(L.INACTIVE_DATE, SYSDATE + 1)
2884: AND NVL(L.SHIP_TO_SITE_FLAG,'N') = 'Y'
2885: AND L.LOCATION_ID = sel_ship_to_location_id
2886: AND NVL (L.INVENTORY_ORGANIZATION_ID, sel_ship_to_organization_id) = sel_ship_to_organization_id

Line 5553: AND NOT EXISTS(SELECT 'Y' from HR_LOCATIONS_ALL L

5549: l_cp_login_id
5550: )
5551:
5552: WHEN ((neg_header_record_data.bill_to_location_id IS NOT NULL AND neg_header_record_data.bill_to_location_id <> -1
5553: AND NOT EXISTS(SELECT 'Y' from HR_LOCATIONS_ALL L
5554: where L.LOCATION_ID = neg_header_record_data.bill_to_location_id
5555: AND NVL(L.BUSINESS_GROUP_ID, NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID, -99) ) = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID, -99)
5556: AND SYSDATE < NVL(L.INACTIVE_DATE, SYSDATE + 1) AND NVL(L.BILL_TO_SITE_FLAG,'N') = 'Y'))
5557: OR (p_is_amendment<>'Y' AND neg_header_record_data.bill_to_location_id IS NULL))

Line 6713: from HR_LOCATIONS_ALL L

6709:
6710: BEGIN
6711: SELECT (nvl(max(location_id), -1))
6712: INTO neg_header_record_data.bill_to_location_id
6713: from HR_LOCATIONS_ALL L
6714: where L.LOCATION_CODE = neg_header_record_data.bill_to_location_code
6715: AND neg_header_record_data.bill_to_location_code IS NOT NULL
6716: AND NVL(L.BUSINESS_GROUP_ID, NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID, -99) ) = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID, -99)
6717: AND SYSDATE < NVL(L.INACTIVE_DATE, SYSDATE + 1) AND NVL(L.BILL_TO_SITE_FLAG,'N') = 'Y';

Line 6740: , hr_locations_all_tl bill_to

6736: po_system_parameters_all psp
6737: , hr_all_organization_units_tl haou
6738: , financials_system_params_all fsp
6739: , gl_sets_of_books sob
6740: , hr_locations_all_tl bill_to
6741: , hr_locations_all_tl ship_to
6742: , ( SELECT po.org_id, po.security_level_code, pon.doctype_id
6743: FROM po_document_types_all po, pon_auc_doctypes pon
6744: WHERE po.document_type_code = pon.document_type_code

Line 6741: , hr_locations_all_tl ship_to

6737: , hr_all_organization_units_tl haou
6738: , financials_system_params_all fsp
6739: , gl_sets_of_books sob
6740: , hr_locations_all_tl bill_to
6741: , hr_locations_all_tl ship_to
6742: , ( SELECT po.org_id, po.security_level_code, pon.doctype_id
6743: FROM po_document_types_all po, pon_auc_doctypes pon
6744: WHERE po.document_type_code = pon.document_type_code
6745: AND po.document_subtype = pon.document_subtype