APPS.WSH_MAPPING_DATA dependencies on HZ_CUST_SITE_USES_ALL

Line 124: FROM HZ_CUST_SITE_USES_ALL

120: ORDER BY cnt DESC;
121:
122: cursor l_site_use_loc_csr(p_site_use_id IN NUMBER) is
123: SELECT LOCATION, contact_id
124: FROM HZ_CUST_SITE_USES_ALL
125: WHERE site_use_id = p_site_use_id;
126:
127: cursor l_cust_ship_to_loc_csr
128: (p_customer_id IN NUMBER,

Line 132: FROM HZ_CUST_SITE_USES_ALL HCSU,

128: (p_customer_id IN NUMBER,
129: p_ship_to_location_id IN NUMBER,
130: p_org_id IN NUMBER) is
131: SELECT HCSU.LOCATION, HCSU.CONTACT_ID
132: FROM HZ_CUST_SITE_USES_ALL HCSU,
133: HZ_CUST_ACCT_SITES_ALL HCAS,
134: HZ_CUST_ACCOUNTS HCA,
135: HZ_PARTY_SITES HPS
136: WHERE HCSU.CUST_ACCT_SITE_ID = HCAS.CUST_ACCT_SITE_ID

Line 154: FROM HZ_CUST_SITE_USES_ALL HCSU,

150: (p_customer_id IN NUMBER,
151: p_ship_to_location_id IN NUMBER,
152: p_org_id IN NUMBER) is
153: SELECT HCSU.LOCATION, HCSU.CONTACT_ID
154: FROM HZ_CUST_SITE_USES_ALL HCSU,
155: HZ_CUST_ACCT_SITES_ALL HCAS,
156: HZ_PARTY_SITES HPS,
157: HZ_CUST_ACCOUNTS HCA,
158: HZ_CUST_ACCT_RELATE_ALL HCAR

Line 841: HZ_CUST_SITE_USES_ALL HCSU,

837: l_count NUMBER;
838: CURSOR loc_cust_cur (p_loc_id NUMBER, p_org_id NUMBER, p_cust_id NUMBER) IS
839: SELECT HCSU.LOCATION --bug 3920178 , HP.PARTY_NAME, HP.PARTY_NUMBER
840: FROM
841: HZ_CUST_SITE_USES_ALL HCSU,
842: HZ_CUST_ACCT_SITES_ALL HCAS,
843: HZ_PARTY_SITES HPS,
844: HZ_CUST_ACCOUNTS HCA,
845: HZ_PARTIES HP,

Line 893: FROM HZ_CUST_SITE_USES_ALL

889:
890: --bug 3920178 {
891: cursor l_site_use_loc_csr(p_site_use_id IN NUMBER) is
892: SELECT LOCATION
893: FROM HZ_CUST_SITE_USES_ALL
894: WHERE site_use_id = p_site_use_id;
895:
896: cursor l_rel_cust_ship_to_loc_csr
897: (p_customer_id IN NUMBER,

Line 901: FROM HZ_CUST_SITE_USES_ALL HCSU,

897: (p_customer_id IN NUMBER,
898: p_ship_to_location_id IN NUMBER,
899: p_org_id IN NUMBER) is
900: SELECT HCSU.LOCATION
901: FROM HZ_CUST_SITE_USES_ALL HCSU,
902: HZ_CUST_ACCT_SITES_ALL HCAS,
903: HZ_PARTY_SITES HPS,
904: HZ_CUST_ACCOUNTS HCA,
905: HZ_CUST_ACCT_RELATE_ALL HCAR

Line 1390: FROM hz_cust_site_uses_all

1386: ORDER BY cnt DESC;
1387:
1388: CURSOR l_site_use_loc_csr(c_site_use_id IN NUMBER) is
1389: SELECT location
1390: FROM hz_cust_site_uses_all
1391: WHERE site_use_id = c_site_use_id;
1392:
1393: CURSOR l_cust_ship_to_loc_csr
1394: (c_customer_id IN NUMBER,

Line 1398: FROM hz_cust_site_uses_all hcsu,

1394: (c_customer_id IN NUMBER,
1395: c_ship_to_location_id IN NUMBER,
1396: c_org_id IN NUMBER) IS
1397: SELECT hcsu.location
1398: FROM hz_cust_site_uses_all hcsu,
1399: hz_cust_acct_sites_all hcas,
1400: hz_cust_accounts hca,
1401: hz_party_sites hps
1402: WHERE hcsu.cust_acct_site_id = hcas.cust_acct_site_id

Line 1419: FROM hz_cust_site_uses_all hcsu,

1415: (c_customer_id IN NUMBER,
1416: c_ship_to_location_id IN NUMBER,
1417: c_org_id IN NUMBER) IS
1418: SELECT hcsu.location
1419: FROM hz_cust_site_uses_all hcsu,
1420: hz_cust_acct_sites_all hcas,
1421: hz_party_sites hps,
1422: hz_cust_accounts hca,
1423: hz_cust_acct_relate_all hcar