View: JAI_RCV_RECEIVE_LINES_V

Product:	JA - Asia/Pacific Localizations
Description:
Implementation/DBA Data:	APPS.JAI_RCV_RECEIVE_LINES_V

View Text

SELECT RCH.SHIPMENT_HEADER_ID
, RCH.RECEIPT_NUM
, RCL.TO_ORGANIZATION_ID ORGANIZATION_ID
, RCH.VENDOR_ID
, RCH.SHIPMENT_NUM
, RCH.SHIPPED_DATE
, RCH.ROWID ROW_ID
, RCL.PO_HEADER_ID
, RCL.PRIMARY_UNIT_OF_MEASURE
, RCL.SHIPMENT_LINE_ID
, RCL.SOURCE_DOCUMENT_CODE
, RCL.REQUISITION_LINE_ID
, RCL.PO_LINE_ID
, RCL.PO_LINE_LOCATION_ID
, RCL.DELIVER_TO_LOCATION_ID LOCATION_ID
, RCL.LINE_NUM
, RT.QUANTITY
, RCL.SHIPMENT_UNIT_PRICE
, RCL.ITEM_ID
, RCL.FROM_ORGANIZATION_ID
, RT.UNIT_OF_MEASURE UOM
, RCL.DESTINATION_TYPE_CODE
, RCL.TO_SUBINVENTORY
, RCL.CREATION_DATE
, RT.TRANSACTION_DATE RECEIPT_DATE
, JRCL.EXCISE_INVOICE_NO
, JRCL.EXCISE_INVOICE_DATE
, JRCL.ONLINE_CLAIM_FLAG
, JRCL.RMA_TYPE
, RT.TRANSACTION_ID /* ADDED CSAHOO - BUG# 6208523 */
FROM RCV_TRANSACTIONS RT
, RCV_SHIPMENT_LINES RCL
, RCV_SHIPMENT_HEADERS RCH
, JAI_RCV_LINES JRCL
WHERE JRCL.SHIPMENT_HEADER_ID = RCL.SHIPMENT_HEADER_ID
AND JRCL.SHIPMENT_LINE_ID = RCL.SHIPMENT_LINE_ID
AND RCL.SHIPMENT_HEADER_ID = RCH.SHIPMENT_HEADER_ID
AND RT.SHIPMENT_HEADER_ID = RCL.SHIPMENT_HEADER_ID
AND RT.SHIPMENT_LINE_ID = RCL.SHIPMENT_LINE_ID
AND ( RT.TRANSACTION_TYPE = 'RECEIVE' OR ( RCL.PO_HEADER_ID IS NULL
AND RT.TRANSACTION_TYPE= 'UNORDERED') OR ( RCL.PO_HEADER_ID IS NOT NULL
AND RT.TRANSACTION_TYPE= 'MATCH') )

Columns