XLA_JE_RULE_SETS_VL

Details

• Schema: FUSION

• Object owner: XLA

• Object type: VIEW

Columns

Name

ROW_ID JE_RULE_SETS_ID APPLICATION_ID AMB_CONTEXT_CODE JERS_TYPE_CODE JERS_CODE EVENT_CLASS_CODE EVENT_TYPE_CODE STATUS_CODE COMPILE_STATUS_CODE TRANSACTION_COA_ID ACCOUNTING_COA_ID COMMITMENT_CONTROL_FLAG DESCRIPTION_TYPE_CODE DESCRIPTION_CODE ACCT_RULE_DEFINITION_ID ACCOUNTING_REQUIRED_FLAG LOCKING_STATUS_FLAG NAME DESCRIPTION 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.JE_RULE_SETS_ID, b.APPLICATION_ID, b.AMB_CONTEXT_CODE, b.JERS_TYPE_CODE, b.JERS_CODE, b.EVENT_CLASS_CODE, b.EVENT_TYPE_CODE, b.STATUS_CODE, b.COMPILE_STATUS_CODE, b.TRANSACTION_COA_ID, b.ACCOUNTING_COA_ID, b.COMMITMENT_CONTROL_FLAG, b.DESCRIPTION_TYPE_CODE, b.DESCRIPTION_CODE, b.ACCT_RULE_DEFINITION_ID, b.ACCOUNTING_REQUIRED_FLAG, b.LOCKING_STATUS_FLAG, t.NAME, t.DESCRIPTION, b.CREATED_BY, b.LAST_UPDATE_DATE, b.LAST_UPDATED_BY, b.LAST_UPDATE_LOGIN, b.CREATION_DATE, b.OBJECT_VERSION_NUMBER FROM XLA_JE_RULE_SETS_TL t, XLA_JE_RULE_SETS_B b WHERE b.APPLICATION_ID = t.APPLICATION_ID AND b.AMB_CONTEXT_CODE = t.AMB_CONTEXT_CODE AND b.JERS_TYPE_CODE = t.JERS_TYPE_CODE AND b.JERS_CODE = t.JERS_CODE AND b.EVENT_CLASS_CODE = t.EVENT_CLASS_CODE AND b.EVENT_TYPE_CODE = t.EVENT_TYPE_CODE AND t.LANGUAGE = USERENV('LANG')