CML_RCPT_DTLS_V

Details

• Schema: FUSION

• Object owner: CML

• Object type: VIEW

Columns

Name
TRANSACTION_ID CMR_PO_LINE_LOCATION_ID ORGANIZATION_NAME RECEIPT_NUMBER RECEIPT_DATE RECEIPT_AGE RECEIPT_QTY RECEIPT_UOM

Query

SQL_Statement

SELECT ct.TRANSACTION_ID ,ct.CMR_PO_LINE_LOCATION_ID ,INV_ORG.ORGANIZATION_NAME,ct.RECEIPT_NUMBER,max(ct.TRANSACTION_DATE) RECEIPT_DATE, round(sysdate-trunc(max(ct.TRANSACTION_DATE))) RECEIPT_AGE, SUM(ct.SOURCE_DOC_QTY) as RECEIPT_QTY, max(SOURCE_DOC_UOM_CODE) receipt_uom FROM CMR_TRANSACTIONS ct,INV_ORGANIZATION_DEFINITIONS_V INV_ORG WHERE ct.TRANSACTION_TYPE IN ('Receipt Into Receiving Inspection', 'Return To Vendor', 'Correction To Receipt', 'Match') AND ct.SHIP_TO_ORGANIZATION_ID = INV_ORG.ORGANIZATION_ID group by ct.CMR_PO_LINE_LOCATION_ID,INV_ORG.ORGANIZATION_NAME,ct.RECEIPT_NUMBER, ct.TRANSACTION_ID