DBA Data[Home] [Help]

APPS.JAI_FA_ASSETS_PKG dependencies on RCV_SHIPMENT_HEADERS

Line 467: FROM PO_HEADERS_ALL A, RCV_TRANSACTIONS B, RCV_SHIPMENT_HEADERS C

463: --This is for Fetching the PO Number for the Receipt Number...............
464: FOR C_FETCH_PO_NUMBER_RECEIPT IN
465: (
466: SELECT SEGMENT1
467: FROM PO_HEADERS_ALL A, RCV_TRANSACTIONS B, RCV_SHIPMENT_HEADERS C
468: WHERE A.PO_HEADER_ID = B.PO_HEADER_ID
469: AND B.SHIPMENT_HEADER_ID = C.SHIPMENT_HEADER_ID
470: AND B.TRANSACTION_TYPE =lv_transaction_type--rchandan for bug#4428980
471: AND A.VENDOR_ID = B.VENDOR_ID