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_PARTY_SITES

Line 187: hz_party_sites ps,

183: from csp_rs_cust_relations rcr,
184: hz_cust_acct_sites cas,
185: hz_cust_site_uses csu,
186: po_location_associations pla,
187: hz_party_sites ps,
188: hz_locations hzl
189: where rcr.customer_id = cas.cust_account_id
190: and cas.cust_acct_site_id = csu.cust_acct_site_id (+)
191: and csu.site_use_code = 'SHIP_TO'

Line 206: hz_party_sites ps,

202: from csp_rs_cust_relations rcr,
203: hz_cust_acct_sites cas,
204: hz_cust_site_uses csu,
205: po_location_associations pla,
206: hz_party_sites ps,
207: hz_locations hzl,
208: jtf_task_assignments jta
209: where rcr.customer_id = cas.cust_account_id
210: and cas.cust_acct_site_id = csu.cust_acct_site_id (+)

Line 359: hz_party_sites ps,

355: INTO l_timezone_id
356: from hz_cust_acct_sites cas,
357: hz_cust_site_uses csu,
358: po_location_associations pla,
359: hz_party_sites ps,
360: hz_locations hzl
361: where cas.cust_acct_site_id = csu.cust_acct_site_id (+)
362: and csu.site_use_code = 'SHIP_TO'
363: and csu.site_use_id = pla.site_use_id