APPS.WSH_MAPPING_DATA dependencies on HZ_CUST_ACCOUNTS

Line 101: hz_cust_accounts hca

97: IS
98: SELECT hp.party_name,
99: hca.account_number
100: FROM hz_parties hp,
101: hz_cust_accounts hca
102: WHERE hca.party_id = hp.party_id
103: AND hca.cust_account_id = p_customer_id;
104:
105: l_org_id NUMBER;

Line 133: HZ_CUST_ACCOUNTS HCA,

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
136: AND HCAS.PARTY_SITE_ID = HPS.PARTY_SITE_ID
137: AND HCAS.CUST_ACCOUNT_ID = HCA.CUST_ACCOUNT_ID

Line 156: HZ_CUST_ACCOUNTS HCA,

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
158: WHERE HCSU.CUST_ACCT_SITE_ID = HCAS.CUST_ACCT_SITE_ID
159: AND HCAS.PARTY_SITE_ID = HPS.PARTY_SITE_ID
160: AND HCAS.CUST_ACCOUNT_ID = HCA.CUST_ACCOUNT_ID

Line 842: HZ_CUST_ACCOUNTS HCA,

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,
844: WSH_LOCATIONS WL1
845: WHERE
846: WL1.wsh_location_id = p_loc_id AND

Line 902: HZ_CUST_ACCOUNTS HCA,

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
904: WHERE HCSU.CUST_ACCT_SITE_ID = HCAS.CUST_ACCT_SITE_ID
905: AND HCAS.PARTY_SITE_ID = HPS.PARTY_SITE_ID
906: AND HCAS.CUST_ACCOUNT_ID = HCA.CUST_ACCOUNT_ID

Line 922: HZ_CUST_ACCOUNTS HCA

918:
919: CURSOR c_cust_info_cur(p_customer_id IN NUMBER) IS
920: SELECT HP.PARTY_NAME, HP.PARTY_NUMBER
921: FROM HZ_PARTIES HP,
922: HZ_CUST_ACCOUNTS HCA
923: WHERE HP.PARTY_ID = HCA.PARTY_ID
924: AND HCA.CUST_ACCOUNT_ID = p_customer_id;
925:
926: l_deliver_to_site_use_id NUMBER;