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_REQUIREMENT dependencies on PO_LOCATION_ASSOCIATIONS

Line 183: po_location_associations pla,

179: hzl.time_zone
180: from csp_rs_cust_relations rcr,
181: hz_cust_acct_sites cas,
182: hz_cust_site_uses csu,
183: po_location_associations pla,
184: hz_party_sites ps,
185: hz_locations hzl
186: where rcr.customer_id = cas.cust_account_id
187: and cas.cust_acct_site_id = csu.cust_acct_site_id (+)

Line 202: po_location_associations pla,

198: hzl.time_zone timezone_id
199: from csp_rs_cust_relations rcr,
200: hz_cust_acct_sites cas,
201: hz_cust_site_uses csu,
202: po_location_associations pla,
203: hz_party_sites ps,
204: hz_locations hzl,
205: jtf_task_assignments jta
206: where rcr.customer_id = cas.cust_account_id

Line 352: po_location_associations pla,

348: SELECT hzl.time_zone time_zone_id
349: INTO l_timezone_id
350: from hz_cust_acct_sites cas,
351: hz_cust_site_uses csu,
352: po_location_associations pla,
353: hz_party_sites ps,
354: hz_locations hzl
355: where cas.cust_acct_site_id = csu.cust_acct_site_id (+)
356: and csu.site_use_code = 'SHIP_TO'