DBA Data[Home] [Help]

APPS.WSH_WSHRDINV_XMLP_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 319: HZ_CUST_SITE_USES_ALL SU,

315: INTO SHIP_TO_CUST_NAME,L_PERSON_TITLE
316: FROM
317: HZ_PARTY_SITES PS,
318: HZ_CUST_ACCT_SITES_ALL CA,
319: HZ_CUST_SITE_USES_ALL SU,
320: HZ_PARTIES HP
321: WHERE SU.SITE_USE_ID = SHIP_TO_SITE_USE_ID
322: AND SU.CUST_ACCT_SITE_ID = CA.CUST_ACCT_SITE_ID
323: AND CA.PARTY_SITE_ID = PS.PARTY_SITE_ID