DBA Data[Home] [Help]

APPS.WSH_LOCATIONS_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 2404: hz_cust_site_uses_all site_uses,

2400: --
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