DBA Data[Home] [Help]

APPS.WSH_WSHRDPAK_XMLP_PKG dependencies on RCV_TRANSACTIONS_INTERFACE

Line 569: RCV_TRANSACTIONS_INTERFACE RTI

565: -- RTV Changes
566: CURSOR C_RTV_BILL_TO_SITE IS
567: SELECT VENDOR_SITE_ID
568: FROM WSH_DELIVERY_DETAILS WDD,
569: RCV_TRANSACTIONS_INTERFACE RTI
570: WHERE WDD.SOURCE_CODE = 'RTV'
571: AND WDD.SOURCE_LINE_ID = F_OE_LINE_ID
572: AND WDD.SOURCE_LINE_ID = RTI.INTERFACE_TRANSACTION_ID
573: AND ROWNUM = 1

Line 1062: RCV_TRANSACTIONS_INTERFACE RTI

1058: -- RTV Changes
1059: CURSOR C_RTV_BILL_TO_SITE IS
1060: SELECT VENDOR_SITE_ID
1061: FROM WSH_DELIVERY_DETAILS WDD,
1062: RCV_TRANSACTIONS_INTERFACE RTI
1063: WHERE WDD.SOURCE_CODE = 'RTV'
1064: AND WDD.SOURCE_LINE_ID = F_OE_LINE_ID
1065: AND WDD.SOURCE_LINE_ID = RTI.INTERFACE_TRANSACTION_ID
1066: AND ROWNUM = 1