DBA Data[Home] [Help]

VIEW: XLA.XLA_PRODUCT_RULES_B#

Source

View Text - Preformatted

select APPLICATION_ID APPLICATION_ID, AMB_CONTEXT_CODE AMB_CONTEXT_CODE, PRODUCT_RULE_TYPE_CODE PRODUCT_RULE_TYPE_CODE, PRODUCT_RULE_CODE PRODUCT_RULE_CODE, TRANSACTION_COA_ID TRANSACTION_COA_ID, ACCOUNTING_COA_ID ACCOUNTING_COA_ID, ENABLED_FLAG ENABLED_FLAG, REQUEST_ID REQUEST_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PRODUCT_RULE_VERSION PRODUCT_RULE_VERSION, COMPILE_STATUS_CODE COMPILE_STATUS_CODE, LOCKING_STATUS_FLAG LOCKING_STATUS_FLAG, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PRODUCT_RULE_HASH_ID PRODUCT_RULE_HASH_ID, UPDATED_FLAG UPDATED_FLAG, VERSION_NUM VERSION_NUM, ZD_EDITION_NAME ZD_EDITION_NAME from "XLA"."XLA_PRODUCT_RULES_B"
View Text - HTML Formatted

SELECT APPLICATION_ID APPLICATION_ID
, AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, PRODUCT_RULE_TYPE_CODE PRODUCT_RULE_TYPE_CODE
, PRODUCT_RULE_CODE PRODUCT_RULE_CODE
, TRANSACTION_COA_ID TRANSACTION_COA_ID
, ACCOUNTING_COA_ID ACCOUNTING_COA_ID
, ENABLED_FLAG ENABLED_FLAG
, REQUEST_ID REQUEST_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PRODUCT_RULE_VERSION PRODUCT_RULE_VERSION
, COMPILE_STATUS_CODE COMPILE_STATUS_CODE
, LOCKING_STATUS_FLAG LOCKING_STATUS_FLAG
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PRODUCT_RULE_HASH_ID PRODUCT_RULE_HASH_ID
, UPDATED_FLAG UPDATED_FLAG
, VERSION_NUM VERSION_NUM
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "XLA"."XLA_PRODUCT_RULES_B"