CMR_XLA_CHARGE_EVENT_COSTS_V

Details

• Schema: FUSION

• Object owner: CMR

• Object type: VIEW

Columns

Name
RCV_CHARGE_ACTUAL_ID RCV_CHARGE_ESTIMATE_ID ACCOUNTING_EVENT_ID CHARGE_ID TROP_CHARGE_LINE_ID CHARGE_LINE_NUMBER TRADE_OPERATION_NUMBER CHARGE_CODE

Query

SQL_Statement

(SELECT DISTINCT crca.rcv_charge_actual_id rcv_charge_actual_id , -1 rcv_charge_estimate_id , crec.accounting_event_id accounting_event_id , crca.charge_id charge_id , crca.trop_charge_line_id trop_charge_line_id , crca.charge_line_number charge_line_number , cto.trade_operation_number trade_operation_number , ccv.charge_code charge_code FROM cml_rcv_charge_actuals crca , cml_charges_vl ccv , cml_trade_operations cto , cmr_rcv_event_costs crec WHERE crca.charge_id=ccv.charge_id and cto.trade_operation_id = crca.trade_operation_id and crec.rcv_charge_actual_id = crca.rcv_charge_actual_id UNION ALL SELECT -1 rcv_charge_actual_id , crce.rcv_charge_estimate_id rcv_charge_estimate_id , crec.accounting_event_id accounting_event_id , crce.charge_id charge_id , crce.trop_charge_line_id trop_charge_line_id , crce.charge_line_number charge_line_number , cto.trade_operation_number trade_operation_number , ccv.charge_code charge_code FROM cml_rcv_charge_estimates crce , cml_charges_vl ccv , cml_trade_operations cto , cmr_rcv_event_costs crec WHERE crce.charge_id=ccv.charge_id and cto.trade_operation_id = crce.trade_operation_id AND crec.rcv_charge_estimate_id = crce.rcv_charge_estimate_id)