APPS.WSH_MAPPING_DATA dependencies on HZ_CUST_SITE_USES_ALL

Line 123: FROM HZ_CUST_SITE_USES_ALL

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

Line 131: FROM HZ_CUST_SITE_USES_ALL HCSU,

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

Line 153: FROM HZ_CUST_SITE_USES_ALL HCSU,

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

Line 839: HZ_CUST_SITE_USES_ALL HCSU,

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

Line 891: FROM HZ_CUST_SITE_USES_ALL

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

Line 899: FROM HZ_CUST_SITE_USES_ALL HCSU,

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