XLA_LINE_DEFINITIONS_B

Details

• Schema: FUSION

• Object owner: XLA

• Object type: VIEW

Columns

Name
AMB_CONTEXT_CODE APPLICATION_ID EVENT_CLASS_CODE EVENT_TYPE_CODE LINE_DEFINITION_OWNER_CODE LINE_DEFINITION_CODE VALIDATION_STATUS_CODE ENABLED_FLAG TRANSACTION_COA_ID ACCOUNTING_COA_ID OBJECT_VERSION_NUMBER CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN BUDGETARY_CONTROL_FLAG

Query

SQL_Statement

SELECT AMB_CONTEXT_CODE ,APPLICATION_ID ,EVENT_CLASS_CODE ,EVENT_TYPE_CODE ,JERS_TYPE_CODE as LINE_DEFINITION_OWNER_CODE ,JERS_CODE as LINE_DEFINITION_CODE ,DECODE(status_code, 'ACTIVE', 'Y', 'INERROR', 'E', 'N') as VALIDATION_STATUS_CODE ,DECODE(status_code, 'INACTIVE', 'N', 'Y') as ENABLED_FLAG ,TRANSACTION_COA_ID ,ACCOUNTING_COA_ID ,OBJECT_VERSION_NUMBER ,CREATION_DATE ,CREATED_BY ,LAST_UPDATE_DATE ,LAST_UPDATED_BY ,LAST_UPDATE_LOGIN ,COMMITMENT_CONTROL_FLAG as BUDGETARY_CONTROL_FLAG from xla_je_rule_sets_b