CMR_XLA_XCC_COMMITMENT_DTLS_V

Details

• Schema: FUSION

• Object owner: CMR

• Object type: VIEW

Columns

Name
ACCOUNTING_EVENT_ID SUBLEDGER_BC_COMPLETE_STATUS ENCUMBRANCE_TYPE_ID

Query

SQL_Statement

SELECT cre.accounting_event_id accounting_event_id, ( CASE /* WHEN (cre.fund_reservation_status IN ('RESERVED_PASSED', 'RESERVED_WARNING', 'RESERVED_CHANGED','RESERVED')) THEN 'Y' */ WHEN cre.event_type_code not in ('TRANSFER_ORDER_DELIVER_TO_EXP','TRANSFER_ORDER_EXPENSE_ADJ','TRANSFER_ORDER_LOGICAL_DELIVER') THEN NULL WHEN (cre.fund_reservation_status LIKE 'RESERVED%' AND cre.fund_reservation_status <> 'RESERVED_NOT_APPLICABLE') THEN 'Y' WHEN cre.fund_reservation_status LIKE 'NOT_RESERVED_FAILED' THEN 'Y' WHEN cre.fund_reservation_status = 'RESERVED_NOT_APPLICABLE' then 'N' WHEN (cre.fund_reservation_status ='NOT_ATTEMPTED' OR cre.fund_reservation_status ='NOT_RESERVED') THEN NULL ELSE 'N' END) subledger_bc_complete_status, getv.encumbrance_type_id encumbrance_type_id FROM cmr_rcv_events cre, gl_encumbrance_types_vl getv WHERE getv.encumbrance_type_code = 'Commitment'