DBA Data[Home] [Help]

APPS.WSH_WSHRDPAK_XMLP_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 551: HZ_CUST_SITE_USES_ALL SU,

547: INTO BILL_TO_LOC_ID
548: FROM
549: HZ_PARTY_SITES PS,
550: HZ_CUST_ACCT_SITES_ALL CA,
551: HZ_CUST_SITE_USES_ALL SU,
552: OE_ORDER_LINES_ALL OLA
553: WHERE OLA.LINE_ID = CF_OE_LINE_ID
554: AND SU.SITE_USE_ID = OLA.INVOICE_TO_ORG_ID
555: AND SU.CUST_ACCT_SITE_ID = CA.CUST_ACCT_SITE_ID

Line 759: HZ_CUST_SITE_USES_ALL SU,

755: INTO BILL_TO_CUST_NAME,L_PERSON_TITLE
756: FROM
757: HZ_PARTY_SITES PS,
758: HZ_CUST_ACCT_SITES_ALL CA,
759: HZ_CUST_SITE_USES_ALL SU,
760: HZ_PARTIES HP,
761: OE_ORDER_LINES_ALL OLA
762: WHERE OLA.LINE_ID = F_OE_LINE_ID
763: AND SU.SITE_USE_ID = OLA.INVOICE_TO_ORG_ID

Line 841: HZ_CUST_SITE_USES_ALL SU,

837: INTO SHIP_TO_CUST_NAME,L_PERSON_TITLE
838: FROM
839: HZ_PARTY_SITES PS,
840: HZ_CUST_ACCT_SITES_ALL CA,
841: HZ_CUST_SITE_USES_ALL SU,
842: HZ_PARTIES HP
843: WHERE SU.SITE_USE_ID = F_SHIP_TO_SITE_USE_ID
844: AND SU.CUST_ACCT_SITE_ID = CA.CUST_ACCT_SITE_ID
845: AND CA.PARTY_SITE_ID = PS.PARTY_SITE_ID

Line 923: HZ_CUST_SITE_USES_ALL SU,

919: INTO BILL_TO_LOC_ID
920: FROM
921: HZ_PARTY_SITES PS,
922: HZ_CUST_ACCT_SITES_ALL CA,
923: HZ_CUST_SITE_USES_ALL SU,
924: OE_ORDER_LINES_ALL OLA
925: WHERE OLA.LINE_ID = F_OE_LINE_ID
926: AND SU.SITE_USE_ID = OLA.INVOICE_TO_ORG_ID
927: AND SU.CUST_ACCT_SITE_ID = CA.CUST_ACCT_SITE_ID