VIEW: APPS.JAI_RCV_RECEIVE_LINES_V

Source

View Text - Preformatted

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.GST_INVOICE_NO, jrcl.GST_INVOICE_DATE, jrcl.excise_invoice_no, jrcl.excise_invoice_date, jrcl.online_claim_flag, jrcl.rma_type, rt.transaction_id, jrcl.attribute1, jrcl.attribute2, jrcl.attribute3, jrcl.attribute4, jrcl.attribute5, jrcl.attribute6, jrcl.attribute7, jrcl.attribute8, jrcl.attribute9, jrcl.attribute10, jrcl.attribute11, jrcl.attribute12, jrcl.attribute13, jrcl.attribute14, jrcl.attribute15, jrcl.attribute_category 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') )

View Text - HTML Formatted

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.GST_INVOICE_NO
, JRCL.GST_INVOICE_DATE
, JRCL.EXCISE_INVOICE_NO
, JRCL.EXCISE_INVOICE_DATE
, JRCL.ONLINE_CLAIM_FLAG
, JRCL.RMA_TYPE
, RT.TRANSACTION_ID
, JRCL.ATTRIBUTE1
, JRCL.ATTRIBUTE2
, JRCL.ATTRIBUTE3
, JRCL.ATTRIBUTE4
, JRCL.ATTRIBUTE5
, JRCL.ATTRIBUTE6
, JRCL.ATTRIBUTE7
, JRCL.ATTRIBUTE8
, JRCL.ATTRIBUTE9
, JRCL.ATTRIBUTE10
, JRCL.ATTRIBUTE11
, JRCL.ATTRIBUTE12
, JRCL.ATTRIBUTE13
, JRCL.ATTRIBUTE14
, JRCL.ATTRIBUTE15
, JRCL.ATTRIBUTE_CATEGORY
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') )