CMR_AP_INVOICE_INFO_V

Details

• Schema: FUSION

• Object owner: CMR

• Object type: VIEW

Columns

Name
CMR_PO_DISTRIBUTION_ID CMR_RCV_TRANSACTION_ID INVOICE_NUMBER TOTAL_INVOICE_QTY CURRENCY_CODE TOTAL_INVOICE_AMOUNT TOTAL_INVOICE_BASE_AMOUNT INVOICE_COUNT CMR_RCV_TRANSACTION_ID_EA

Query

SQL_Statement

SELECT CMR_PO_DISTRIBUTION_ID, CMR_RCV_TRANSACTION_ID, DECODE (COUNT(DISTINCT INVOICE_NUMBER), 1, MIN(INVOICE_NUMBER), 'Multiple Invoices') INVOICE_NUMBER, SUM(NVL(INVOICE_QTY, 0)) TOTAL_INVOICE_QTY, MIN(CURRENCY_CODE) CURRENCY_CODE, SUM(INVOICE_AMT) TOTAL_INVOICE_AMOUNT, SUM(INVOICE_BASE_AMOUNT) TOTAL_INVOICE_BASE_AMOUNT, COUNT(DISTINCT INVOICE_NUMBER) INVOICE_COUNT, NVL(CMR_RCV_TRANSACTION_ID, -1) CMR_RCV_TRANSACTION_ID_EA FROM CMR_AP_INVOICE_DTLS WHERE accounting_date <= NVL(SYS_CONTEXT('CMR_OTBI_PARAMS','p_receipt_to_date'),to_timestamp('12/31/4712','MM/DD/YYYY')) GROUP BY CMR_PO_DISTRIBUTION_ID, CMR_RCV_TRANSACTION_ID