DBA Data[Home] [Help]

APPS.WSH_WSHRDINV_XMLP_PKG dependencies on HZ_PARTY_SITES

Line 334: HZ_PARTY_SITES PS,

330: ,HP.PERSON_TITLE) TITLE
331: INTO SHIP_TO_CUST_NAME,L_PERSON_TITLE
332: FROM
333: HZ_PARTY_SITE_USES PSU,
334: HZ_PARTY_SITES PS,
335: HZ_PARTIES HP
336: WHERE PSU.PARTY_SITE_USE_ID = SHIP_TO_SITE_USE_ID
337: AND PSU.SITE_USE_TYPE = 'PURCHASING'
338: AND PS.PARTY_SITE_ID = PSU.PARTY_SITE_ID

Line 347: HZ_PARTY_SITES PS,

343: NVL(HP.PERSON_PRE_NAME_ADJUNCT
344: ,HP.PERSON_TITLE) TITLE
345: INTO SHIP_TO_CUST_NAME,L_PERSON_TITLE
346: FROM
347: HZ_PARTY_SITES PS,
348: HZ_CUST_ACCT_SITES_ALL CA,
349: HZ_CUST_SITE_USES_ALL SU,
350: HZ_PARTIES HP
351: WHERE SU.SITE_USE_ID = SHIP_TO_SITE_USE_ID