DBA Data[Home] [Help]

APPS.WSH_LOCATIONS_PKG dependencies on HZ_CUST_ACCT_SITES_ALL

Line 2405: hz_cust_acct_sites_all acct_sites,

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