Product: | GCS - Financial Consolidation Hub |
---|---|
Description: | Consolidation treatments information |
Implementation/DBA Data: | APPS.GCS_TREATMENTS_VL |
SELECT B.ROWID ROW_ID
, B.TREATMENT_ID TREATMENT_ID
, B.CONSOLIDATION_TYPE_CODE CONSOLIDATION_TYPE_CODE
, B.ENABLED_FLAG ENABLED_FLAG
, B.OPERATOR_LOW_CODE OPERATOR_LOW_CODE
, B.OPERATOR_HIGH_CODE OPERATOR_HIGH_CODE
, B.LAST_UPDATE_DATE LAST_UPDATE_DATE
, B.LAST_UPDATED_BY LAST_UPDATED_BY
, B.CREATION_DATE CREATION_DATE
, B.CREATED_BY CREATED_BY
, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, B.OWNERSHIP_PERCENT_LOW OWNERSHIP_PERCENT_LOW
, B.OWNERSHIP_PERCENT_HIGH OWNERSHIP_PERCENT_HIGH
, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, T.TREATMENT_NAME TREATMENT_NAME
, T.DESCRIPTION DESCRIPTION
FROM GCS_TREATMENTS_B B
, GCS_TREATMENTS_TL T
WHERE B.TREATMENT_ID = T.TREATMENT_ID
AND T.LANGUAGE = USERENV('LANG')