APPS.CSP_PARTS_ORDER dependencies on HZ_CUST_ACCT_SITES

Line 1163: HZ_CUST_ACCT_SITES_ALL cust_acct,

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
1167: AND cust_acct.cust_acct_site_id = site_use.cust_acct_site_id;

Line 1183: hz_cust_acct_sites cas,

1179: CURSOR rs_loc_exists_cur(p_inv_loc_id NUMBER, p_resource_id NUMBER, p_resource_type VARCHAR2) IS
1180:
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

Line 1218: FROM HZ_CUST_ACCT_SITES_ALL cust_acct,

1214:
1215: -- bug # 6471559
1216: cursor get_bill_to_for_sr (p_rqmt_header_id NUMBER) IS
1217: SELECT site_use.site_use_id
1218: FROM HZ_CUST_ACCT_SITES_ALL cust_acct,
1219: HZ_CUST_SITE_USES_ALL site_use,
1220: hz_party_site_uses hpsu,
1221: cs_incidents_all cia,
1222: csp_requirement_headers_v req