View: JAI_RCV_RTV_LINES_V

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

View Text

SELECT JRT.TRANSACTION_ID
, JRT.PARENT_TRANSACTION_ID
, JRT.ORGANIZATION_ID
, JRT.SHIPMENT_HEADER_ID
, JRT.SHIPMENT_LINE_ID
, RCL.LINE_NUM
, JRT.RECEIPT_NUM
, RT.VENDOR_ID
, RT.VENDOR_SITE_ID
, JRT.ROWID ROW_ID
, JRT.LOCATION_ID
, JRT.QUANTITY
, RCL.ITEM_ID
, RCL.ITEM_DESCRIPTION
, JRT.EXCISE_INVOICE_NO
, JRT.VAT_INVOICE_NO
, JRT.GST_INVOICE_NO
, JRT.ATTRIBUTE_CATEGORY
, JRT.EXCISE_INV_GEN_STATUS
, JRT.VAT_INV_GEN_STATUS
, JRT.EXCISE_INV_GEN_NUMBER
, JRT.VAT_INV_GEN_NUMBER
, JRT.CENVAT_COSTED_FLAG
, JRT.TRX_INFORMATION
, JRT.CREATION_DATE
, JRT.TRANSACTION_DATE
, RT.SOURCE_DOC_QUANTITY
, RT.PO_UNIT_PRICE
, RT.RMA_REFERENCE
, JRT.ATTRIBUTE1
, JRT.ATTRIBUTE2
, JRT.ATTRIBUTE3
, JRT.ATTRIBUTE4
, JRT.ATTRIBUTE5
, JRT.ATTRIBUTE6
, JRT.ATTRIBUTE7
, JRT.ATTRIBUTE8
, JRT.ATTRIBUTE9
, JRT.ATTRIBUTE10
, JRT.ATTRIBUTE11
, JRT.ATTRIBUTE12
, JRT.ATTRIBUTE13
, JRT.ATTRIBUTE14
, JRT.ATTRIBUTE15
FROM JAI_RCV_TRANSACTIONS JRT
, RCV_TRANSACTIONS RT
, RCV_SHIPMENT_LINES RCL
WHERE RT.TRANSACTION_ID= JRT.TRANSACTION_ID
AND JRT.SHIPMENT_LINE_ID = RCL.SHIPMENT_LINE_ID
AND JRT.TRANSACTION_TYPE = 'RETURN TO VENDOR'

Columns