1. Tables and Views for SCM
  2. CMR_XLA_XCC_DETAILS_V

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'