DBA Data[Home] [Help]

APPS.WSH_LOCATIONS_PKG dependencies on HZ_CUST_ACCT_SITES_ALL

Line 2402: hz_cust_acct_sites_all acct_sites,

2398: CURSOR c_convert(p_int_cust_loc_id NUMBER,p_customer_id NUMBER) IS
2399: SELECT ploc.LOCATION_ID internal_org_location_id
2400: FROM PO_LOCATION_ASSOCIATIONS_ALL ploc,
2401: hz_cust_site_uses_all site_uses,
2402: hz_cust_acct_sites_all acct_sites,
2403: HZ_PARTY_SITES sites
2404: WHERE ploc.SITE_USE_ID = site_uses.SITE_USE_ID
2405: AND site_uses.CUST_ACCT_SITE_ID = acct_sites.CUST_ACCT_SITE_ID
2406: AND acct_sites.PARTY_SITE_ID = sites.PARTY_SITE_ID