eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

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.ATTRIBUTE_CATEGORY
, JRT.ATTRIBUTE1
, JRT.ATTRIBUTE2
, JRT.ATTRIBUTE3
, JRT.ATTRIBUTE4
, JRT.CREATION_DATE
, JRT.TRANSACTION_DATE
, RT.SOURCE_DOC_QUANTITY
, RT.PO_UNIT_PRICE
, RT.RMA_REFERENCE
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

Name
TRANSACTION_ID
PARENT_TRANSACTION_ID
ORGANIZATION_ID
SHIPMENT_HEADER_ID
SHIPMENT_LINE_ID
LINE_NUM
RECEIPT_NUM
VENDOR_ID
VENDOR_SITE_ID
ROW_ID
LOCATION_ID
QUANTITY
ITEM_ID
ITEM_DESCRIPTION
EXCISE_INVOICE_NO
VAT_INVOICE_NO
ATTRIBUTE_CATEGORY
EXCISE_ACTION
VAT_ACTION
EXCISE_BATCH_NUM
VAT_BATCH_NUM
CREATION_DATE
TRANSACTION_DATE
SOURCE_DOC_QUANTITY
PO_UNIT_PRICE
RMA_REFERENCE