[Home] [Help]
View: GCS_ELIM_RULES_VL
Product: | GCS - Financial Consolidation Hub |
Description: | Elimination rules information |
Implementation/DBA Data: |
APPS.GCS_ELIM_RULES_VL
|
View Text
SELECT B.RULE_ID
, B.TRANSACTION_TYPE_CODE
, B.FROM_TREATMENT_ID
, B.TO_TREATMENT_ID
, B.SEEDED_RULE_FLAG
, B.ENABLED_FLAG
, B.OBJECT_VERSION_NUMBER
, TL.RULE_NAME RULE_NAME
, TL.DESCRIPTION DESCRIPTION
, B.RULE_TYPE_CODE
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
FROM GCS_ELIM_RULES_B B
, GCS_ELIM_RULES_TL TL
WHERE B.RULE_ID = TL.RULE_ID
AND TL.LANGUAGE = USERENV('LANG')
Columns
Name |
RULE_ID |
TRANSACTION_TYPE_CODE |
FROM_TREATMENT_ID |
TO_TREATMENT_ID |
SEEDED_RULE_FLAG |
ENABLED_FLAG |
OBJECT_VERSION_NUMBER |
RULE_NAME |
DESCRIPTION |
RULE_TYPE_CODE |
CREATION_DATE |
CREATED_BY |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |