XLA_MAPPING_SETS_VL

Details

• Schema: FUSION

• Object owner: XLA

• Object type: VIEW

Columns

Name
ROW_ID MAPPING_SET_CODE MAPPING_SET_ID APPLICATION_ID AMB_CONTEXT_CODE NAME DESCRIPTION FLEXFIELD_ASSIGN_MODE_CODE FLEXFIELD_SEGMENT_CODE ENABLED_FLAG UPDATED_FLAG VERSION_NUM NUM_INPUTS DEFAULT_VALUE OWNER_CODE OBJECT_VERSION_NUMBER CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT b.ROWID ROW_ID, b.MAPPING_SET_CODE MAPPING_SET_CODE, b.MAPPING_SET_ID MAPPING_SET_ID, b.APPLICATION_ID APPLICATION_ID, b.AMB_CONTEXT_CODE AMB_CONTEXT_CODE, t.NAME NAME, t.DESCRIPTION DESCRIPTION, b.FLEXFIELD_ASSIGN_MODE_CODE FLEXFIELD_ASSIGN_MODE_CODE, b.FLEXFIELD_SEGMENT_CODE FLEXFIELD_SEGMENT_CODE, b.ENABLED_FLAG ENABLED_FLAG, b.UPDATED_FLAG UPDATED_FLAG, b.VERSION_NUM VERSION_NUM, b.NUM_INPUTS NUM_INPUTS, b.DEFAULT_VALUE DEFAULT_VALUE, b.OWNER_CODE OWNER_CODE, b.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, b.CREATION_DATE CREATION_DATE, b.CREATED_BY CREATED_BY, b.LAST_UPDATE_DATE LAST_UPDATE_DATE, b.LAST_UPDATED_BY LAST_UPDATED_BY, b.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM XLA_MAPPING_SETS_B b, XLA_MAPPING_SETS_TL t WHERE b.APPLICATION_ID = t.APPLICATION_ID AND b.AMB_CONTEXT_CODE = t.AMB_CONTEXT_CODE AND b.MAPPING_SET_CODE = t.MAPPING_SET_CODE AND t.LANGUAGE = USERENV('LANG')