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.CSP_PARTS_ORDER dependencies on PO_LOCATION_ASSOCIATIONS

Line 1162: FROM PO_LOCATION_ASSOCIATIONS_ALL pol,

1158:
1159: -- Get site_use_id for the inventory location id
1160: CURSOR cust_site_cur IS
1161: SELECT pol.customer_id, pol.site_use_id, cust_acct.cust_account_id
1162: FROM PO_LOCATION_ASSOCIATIONS_ALL pol,
1163: HZ_CUST_ACCT_SITES_ALL cust_acct,
1164: HZ_CUST_SITE_USES_ALL site_use
1165: WHERE pol.location_id = l_header_rec.ship_to_location_id
1166: AND site_use.site_use_id = pol.site_use_id

Line 1185: po_location_associations pla,

1181: SELECT ps.location_id site_loc_id
1182: from csp_rs_cust_relations rcr,
1183: hz_cust_acct_sites cas,
1184: hz_cust_site_uses csu,
1185: po_location_associations pla,
1186: hz_party_sites ps
1187: where rcr.customer_id = cas.cust_account_id
1188: and cas.cust_acct_site_id = csu.cust_acct_site_id (+)
1189: and csu.site_use_code = 'SHIP_TO'