VIEW: APPS.JAI_RCV_RTV_LINES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'