DBA Data[Home] [Help]

APPS.JAI_FA_ASSETS_PKG dependencies on PO_HEADERS_ALL

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

469: --This is for Fetching the PO Number for the Receipt Number...............
470: FOR C_FETCH_PO_NUMBER_RECEIPT IN
471: (
472: SELECT SEGMENT1
473: FROM PO_HEADERS_ALL A, RCV_TRANSACTIONS B, RCV_SHIPMENT_HEADERS C
474: WHERE A.PO_HEADER_ID = B.PO_HEADER_ID
475: AND B.SHIPMENT_HEADER_ID = C.SHIPMENT_HEADER_ID
476: AND B.TRANSACTION_TYPE =lv_transaction_type--rchandan for bug#4428980
477: AND A.VENDOR_ID = B.VENDOR_ID