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 HZ_LOCATIONS

Line 185: hz_locations hzl

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 (+)
188: and csu.site_use_code = 'SHIP_TO'
189: and csu.site_use_id = pla.site_use_id

Line 204: hz_locations hzl,

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
207: and cas.cust_acct_site_id = csu.cust_acct_site_id (+)
208: and csu.site_use_code = 'SHIP_TO'

Line 354: hz_locations hzl

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'
357: and csu.site_use_id = pla.site_use_id
358: and pla.location_id = l_header_rec.ship_to_location_id