XLA_SEG_RULES_VL

Details

• Schema: FUSION

• Object owner: XLA

• Object type: VIEW

Columns

Name
ROW_ID APPLICATION_ID AMB_CONTEXT_CODE SEGMENT_RULE_TYPE_CODE SEGMENT_RULE_CODE NAME DESCRIPTION TRANSACTION_COA_ID ACCOUNTING_COA_ID FLEXFIELD_SEGMENT_CODE FLEXFIELD_ASSIGN_MODE_CODE ENABLED_FLAG VERSION_NUM UPDATED_FLAG FLEX_VALUE_SET_ID CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER SEGMENT_RULE_ID

Query

SQL_Statement

SELECT b.ROWID ROW_ID, b.APPLICATION_ID, b.AMB_CONTEXT_CODE, b.SEGMENT_RULE_TYPE_CODE, b.SEGMENT_RULE_CODE, t.NAME, t.DESCRIPTION, b.TRANSACTION_COA_ID, b.ACCOUNTING_COA_ID, b.FLEXFIELD_SEGMENT_CODE, b.FLEXFIELD_ASSIGN_MODE_CODE, b.ENABLED_FLAG, b.VERSION_NUM, b.UPDATED_FLAG, b.FLEX_VALUE_SET_ID, b.CREATION_DATE, b.CREATED_BY, b.LAST_UPDATE_DATE, b.LAST_UPDATED_BY, b.LAST_UPDATE_LOGIN, b.OBJECT_VERSION_NUMBER, b.SEGMENT_RULE_ID FROM XLA_SEG_RULES_B b, XLA_SEG_RULES_TL t WHERE b.APPLICATION_ID = t.APPLICATION_ID AND b.AMB_CONTEXT_CODE = t.AMB_CONTEXT_CODE AND b.SEGMENT_RULE_TYPE_CODE = t.SEGMENT_RULE_TYPE_CODE AND b.SEGMENT_RULE_CODE = t.SEGMENT_RULE_CODE AND t.LANGUAGE = USERENV('LANG')