DBA Data[Home] [Help]

APPS.WSH_MAPPING_DATA dependencies on HZ_CUST_ACCT_SITES_ALL

Line 132: HZ_CUST_ACCT_SITES_ALL HCAS,

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

Line 154: HZ_CUST_ACCT_SITES_ALL HCAS,

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
158: WHERE HCSU.CUST_ACCT_SITE_ID = HCAS.CUST_ACCT_SITE_ID

Line 840: HZ_CUST_ACCT_SITES_ALL HCAS,

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,
844: WSH_LOCATIONS WL1

Line 900: HZ_CUST_ACCT_SITES_ALL HCAS,

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
904: WHERE HCSU.CUST_ACCT_SITE_ID = HCAS.CUST_ACCT_SITE_ID