XLA_LINE_DEFN_ADR_ASSGNS

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 ACCOUNTING_LINE_TYPE_CODE ACCOUNTING_LINE_CODE FLEXFIELD_SEGMENT_CODE SEGMENT_RULE_TYPE_CODE SEGMENT_RULE_CODE OBJECT_VERSION_NUMBER CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN SIDE_CODE INHERIT_ADR_FLAG SEGMENT_RULE_APPL_ID ADR_VERSION_NUM

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 ,ACCOUNTING_LINE_TYPE_CODE ,ACCOUNTING_LINE_CODE ,FLEXFIELD_SEGMENT_CODE ,SEGMENT_RULE_TYPE_CODE ,SEGMENT_RULE_CODE ,OBJECT_VERSION_NUMBER ,CREATION_DATE ,CREATED_BY ,LAST_UPDATE_DATE ,LAST_UPDATED_BY ,LAST_UPDATE_LOGIN ,decode(SIDE_CODE, 'GAIN', 'CREDIT', 'LOSS', 'DEBIT', 'ALL', 'ALL', 'NA') as SIDE_CODE ,INHERIT_ADR_FLAG ,SEGMENT_RULE_APPL_ID ,ADR_VERSION_NUM from xla_jers_adr_lines