APPS.CSP_PARTS_ORDER dependencies on HZ_PARTY_SITES

Line 1186: hz_party_sites ps

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'
1190: and csu.site_use_id = pla.site_use_id