XLA_PRODUCT_RULES

Details

Schema: FUSION
Object owner: XLA
Object type: VIEW

Columns

Name
ROW_ID ENABLED_FLAG REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN PRODUCT_RULE_VERSION APPLICATION_ID PRODUCT_RULE_TYPE_CODE PRODUCT_RULE_CODE TRANSACTION_COA_ID ACCOUNTING_COA_ID PRODUCT_RULE_HASH_ID AMB_CONTEXT_CODE COMPILE_STATUS_CODE LOCKING_STATUS_FLAG VERSION_NUM UPDATED_FLAG OBJECT_VERSION_NUMBER NAME DESCRIPTION

Name

ROW_ID

ENABLED_FLAG

REQUEST_ID

JOB_DEFINITION_NAME

JOB_DEFINITION_PACKAGE

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

PRODUCT_RULE_VERSION

APPLICATION_ID

PRODUCT_RULE_TYPE_CODE

PRODUCT_RULE_CODE

TRANSACTION_COA_ID

ACCOUNTING_COA_ID

PRODUCT_RULE_HASH_ID

AMB_CONTEXT_CODE

COMPILE_STATUS_CODE

LOCKING_STATUS_FLAG

VERSION_NUM

UPDATED_FLAG

OBJECT_VERSION_NUMBER

NAME

DESCRIPTION

Query

SQL_Statement
SELECT b.ROWID row_id, b.ENABLED_FLAG, b.REQUEST_ID, b.JOB_DEFINITION_NAME, b.JOB_DEFINITION_PACKAGE, b.CREATION_DATE, b.CREATED_BY, b.LAST_UPDATE_DATE, b.LAST_UPDATED_BY, b.LAST_UPDATE_LOGIN, b.PRODUCT_RULE_VERSION, b.APPLICATION_ID, b.PRODUCT_RULE_TYPE_CODE, b.PRODUCT_RULE_CODE, b.TRANSACTION_COA_ID, b.ACCOUNTING_COA_ID, b.PRODUCT_RULE_HASH_ID, b.AMB_CONTEXT_CODE, b.COMPILE_STATUS_CODE, b.LOCKING_STATUS_FLAG, b.VERSION_NUM, b.UPDATED_FLAG, b.OBJECT_VERSION_NUMBER, t.NAME, t.DESCRIPTION FROM XLA_PRODUCT_RULES_TL t, XLA_PRODUCT_RULES_B b WHERE b.APPLICATION_ID = t.APPLICATION_ID AND b.AMB_CONTEXT_CODE = t.AMB_CONTEXT_CODE AND b.PRODUCT_RULE_TYPE_CODE = t.PRODUCT_RULE_TYPE_CODE AND b.PRODUCT_RULE_CODE = t.PRODUCT_RULE_CODE AND t.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

b.ROWID row_id,

b.ENABLED_FLAG,

b.REQUEST_ID,

b.JOB_DEFINITION_NAME,

b.JOB_DEFINITION_PACKAGE,

b.CREATION_DATE,

b.CREATED_BY,

b.LAST_UPDATE_DATE,

b.LAST_UPDATED_BY,

b.LAST_UPDATE_LOGIN,

b.PRODUCT_RULE_VERSION,

b.APPLICATION_ID,

b.PRODUCT_RULE_TYPE_CODE,

b.PRODUCT_RULE_CODE,

b.TRANSACTION_COA_ID,

b.ACCOUNTING_COA_ID,

b.PRODUCT_RULE_HASH_ID,

b.AMB_CONTEXT_CODE,

b.COMPILE_STATUS_CODE,

b.LOCKING_STATUS_FLAG,

b.VERSION_NUM,

b.UPDATED_FLAG,

b.OBJECT_VERSION_NUMBER,

t.NAME,

t.DESCRIPTION

FROM

XLA_PRODUCT_RULES_TL t,

XLA_PRODUCT_RULES_B b

WHERE

b.APPLICATION_ID = t.APPLICATION_ID AND b.AMB_CONTEXT_CODE = t.AMB_CONTEXT_CODE AND b.PRODUCT_RULE_TYPE_CODE = t.PRODUCT_RULE_TYPE_CODE AND b.PRODUCT_RULE_CODE = t.PRODUCT_RULE_CODE AND t.LANGUAGE = USERENV('LANG')