XLA_ASSIGNMENT_DEFNS_VL

Details

• Schema: FUSION

• Object owner: XLA

• Object type: VIEW

Columns

Name
ROW_ID PROGRAM_CODE PROGRAM_OWNER_CODE ASSIGNMENT_ID ASSIGNMENT_CODE ASSIGNMENT_OWNER_CODE LEDGER_ID ENABLED_FLAG NAME CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATION_DATE OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT b.rowid ROW_ID , b.program_code PROGRAM_CODE , b.program_owner_code PROGRAM_OWNER_CODE , b.assignment_id ASSIGNMENT_ID, b.assignment_code ASSIGNMENT_CODE , b.assignment_owner_code ASSIGNMENT_OWNER_CODE , b.ledger_id LEDGER_ID , b.enabled_flag ENABLED_FLAG, t.name NAME , 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 , b.creation_date CREATION_DATE, b.object_version_number OBJECT_VERSION_NUMBER FROM xla_assignment_defns_tl t ,xla_assignment_defns_b b WHERE b.Program_code = t.Program_code AND b.Program_owner_code = t.Program_owner_code AND b.assignment_code = t.assignment_code AND b.assignment_owner_code = t.assignment_owner_code AND t.language = USERENV('LANG')