DBA Data[Home] [Help]

APPS.WSH_OTM_REF_DATA_GEN_PKG dependencies on HZ_CUST_ACCT_SITES_ALL

Line 315: HZ_CUST_ACCT_SITES_ALL HCAS,

311: FROM WSH_DELIVERY_DETAILS WDD,
312: WSH_DELIVERY_ASSIGNMENTS WDA,
313: HZ_PARTY_SITES HPS,
314: WSH_LOCATIONS WSL,
315: HZ_CUST_ACCT_SITES_ALL HCAS,
316: HZ_CUST_ACCOUNT_ROLES HCAR
317: WHERE WDA.delivery_id = p_delivery_id
318: AND WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
319: AND WDD.SHIP_TO_LOCATION_ID = WSL.WSH_LOCATION_ID