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.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'

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.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'