CMR_XLA_XCC_DETAILS_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.event_type_code = 'EXPENSE_ADJUSTMENT' THEN NULL /* WHEN (cre.fund_reservation_status IN ('RESERVED_PASSED', 'RESERVED_WARNING', 'RESERVED_CHANGED','RESERVED')) THEN 'Y' */ 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 = 'Obligation' |