CMR_XLA_DISTRIBUTION_LINES_V

Details

• Schema: FUSION

• Object owner: CMR

• Object type: VIEW

Columns

Name
CMR_SUB_LEDGER_ID LINE_NUMBER EVENT_ID ACCOUNTING_LINE_TYPE ACCOUNTING_EVENT_ID LEDGER_AMOUNT ENTERED_CURRENCY_AMOUNT ACCOUNTED_QTY ENTERED_CURRENCY_CODE EA_ENTERED_CURRENCY_CODE LEDGER_CURRENCY_CODE CODE_COMBINATION_ID PJC_TXN_STATUS_CODE EXCHANGE_RATE_TYPE EXCHANGE_RATE EXCHANGE_DATE EVENT_COST_SOURCE EVENT_COST_SOURCE_TYPE TRANSACTION_TAX_ID TRADE_EVENT_TAX_ID

Query

SQL_Statement

SELECT crd.cmr_sub_ledger_id cmr_sub_ledger_id , crd.line_number line_number , crd.event_id event_id , crd.accounting_line_type accounting_line_type , crd.accounting_event_id accounting_event_id , crd.ledger_amount ledger_amount , crd.entered_currency_amount entered_currency_amount , crd.accounted_qty accounted_qty , crd.entered_currency_code entered_currency_code , crd.ea_entered_currency_code ea_entered_currency_code , crd.ledger_currency_code ledger_currency_code , crd.code_combination_id code_combination_id , crd.pjc_txn_status_code pjc_txn_status_code ,DECODE(crd.entered_currency_code,crd.ledger_currency_code,NULL,crec.currency_conversion_type) exchange_rate_type , crec.currency_conversion_rate exchange_rate , crec.currency_conversion_date exchange_date , crec.event_cost_source event_cost_source , crec.event_cost_source_type event_cost_source_type , crec.transaction_tax_id transaction_tax_id , crec.trade_event_tax_id FROM cmr_rcv_distributions crd, cmr_rcv_event_costs crec WHERE crd.accounting_event_id = crec.accounting_event_id AND crd.event_cost_id = crec.event_cost_id