DBA Data[Home] [Help]

APPS.WSH_WSHRDPAK_XMLP_PKG dependencies on RCV_TRANSACTIONS

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 577: RCV_TRANSACTIONS RT

573: AND ROWNUM = 1
574: UNION
575: SELECT VENDOR_SITE_ID
576: FROM WSH_DELIVERY_DETAILS WDD,
577: RCV_TRANSACTIONS RT
578: WHERE WDD.SOURCE_CODE = 'RTV'
579: AND WDD.SOURCE_LINE_ID = F_OE_LINE_ID
580: AND WDD.DELIVERY_DETAIL_ID = RT.INTERFACE_SOURCE_LINE_ID
581: AND WDD.RELEASED_STATUS = 'C'

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

Line 1070: RCV_TRANSACTIONS RT

1066: AND ROWNUM = 1
1067: UNION
1068: SELECT VENDOR_SITE_ID
1069: FROM WSH_DELIVERY_DETAILS WDD,
1070: RCV_TRANSACTIONS RT
1071: WHERE WDD.SOURCE_CODE = 'RTV'
1072: AND WDD.SOURCE_LINE_ID = F_OE_LINE_ID
1073: AND WDD.DELIVERY_DETAIL_ID = RT.INTERFACE_SOURCE_LINE_ID
1074: AND WDD.RELEASED_STATUS = 'C'