CMR_PJC_AP_INVOICE_VARIANCES

Details

Schema: FUSION
Object owner: CMR
Object type: VIEW

Columns

Name
CMR_SUB_LEDGER_ID ACCOUNTING_EVENT_ID INVOICE_DIST_ID INVOICE_ID INVOICE_DISTRIBUTION_TYPE INVOICE_NUMBER INVOICE_LINE_NUMBER PO_DISTRIBUTION_ID RCV_TRANSACTION_ID CMR_PO_DISTRIBUTION_ID INVOICE_BASE_AMOUNT INVOICE_AMT SELF_ASSESSED_FLAG

Name

CMR_SUB_LEDGER_ID

ACCOUNTING_EVENT_ID

INVOICE_DIST_ID

INVOICE_ID

INVOICE_DISTRIBUTION_TYPE

INVOICE_NUMBER

INVOICE_LINE_NUMBER

PO_DISTRIBUTION_ID

RCV_TRANSACTION_ID

CMR_PO_DISTRIBUTION_ID

INVOICE_BASE_AMOUNT

INVOICE_AMT

SELF_ASSESSED_FLAG

Query

SQL_Statement
SELECT crd.cmr_sub_ledger_id cmr_sub_ledger_id, cre.accounting_event_id accounting_event_id, to_number(caid.external_system_ref_id) invoice_dist_id, caid.invoice_id invoice_id, caid.invoice_distribution_type invoice_distribution_type, caid.invoice_number invoice_number, caid.invoice_line_number invoice_line_number, caid.po_distribution_id po_distribution_id, caid.rcv_transaction_id rcv_transaction_id, caid.cmr_po_distribution_id cmr_po_distribution_id, caid.invoice_base_amount invoice_base_amount, caid.invoice_amt invoice_amt, caid.self_assessed_flag FROM CMR_AP_INVOICE_DTLS caid, CMR_RCV_EVENTS cre, CMR_RCV_EVENT_COSTS crec, CMR_RCV_DISTRIBUTIONS crd WHERE caid.cmr_ap_invoice_dist_id = cre.event_source_id AND caid.cmr_po_distribution_id = cre.cmr_po_distribution_id AND cre.accounting_event_id = crec.accounting_event_id AND cre.accounting_event_id = crd.accounting_event_id AND crec.accounting_event_id = crd.accounting_event_id AND crec.event_cost_id = crd.event_cost_id AND crec.event_cost_source_type = caid.invoice_distribution_type AND crec.event_cost_source = 'AP_VARIANCE' AND cre.event_type_code = 'EXPENSE_ADJUSTMENT' AND crd.accounting_line_type = 'EXPENSE' AND cre.accounted_flag = 'F'

SQL_Statement

SELECT crd.cmr_sub_ledger_id cmr_sub_ledger_id,

cre.accounting_event_id accounting_event_id,

to_number(caid.external_system_ref_id) invoice_dist_id,

caid.invoice_id invoice_id,

caid.invoice_distribution_type invoice_distribution_type,

caid.invoice_number invoice_number,

caid.invoice_line_number invoice_line_number,

caid.po_distribution_id po_distribution_id,

caid.rcv_transaction_id rcv_transaction_id,

caid.cmr_po_distribution_id cmr_po_distribution_id,

caid.invoice_base_amount invoice_base_amount,

caid.invoice_amt invoice_amt,

caid.self_assessed_flag

FROM CMR_AP_INVOICE_DTLS caid,

CMR_RCV_EVENTS cre,

CMR_RCV_EVENT_COSTS crec,

CMR_RCV_DISTRIBUTIONS crd

WHERE caid.cmr_ap_invoice_dist_id = cre.event_source_id

AND caid.cmr_po_distribution_id = cre.cmr_po_distribution_id

AND cre.accounting_event_id = crec.accounting_event_id

AND cre.accounting_event_id = crd.accounting_event_id

AND crec.accounting_event_id = crd.accounting_event_id

AND crec.event_cost_id = crd.event_cost_id

AND crec.event_cost_source_type = caid.invoice_distribution_type

AND crec.event_cost_source = 'AP_VARIANCE'

AND cre.event_type_code = 'EXPENSE_ADJUSTMENT'

AND crd.accounting_line_type = 'EXPENSE'

AND cre.accounted_flag = 'F'