eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: GCS_TREATMENTS_VL

Product:	GCS - Financial Consolidation Hub (Obsolete)
Description:	Consolidation treatments information
Implementation/DBA Data:	Not implemented in this database

View Text

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')

Columns

Name
ROW_ID
TREATMENT_ID
CONSOLIDATION_TYPE_CODE
ENABLED_FLAG
OPERATOR_LOW_CODE
OPERATOR_HIGH_CODE
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
OWNERSHIP_PERCENT_LOW
OWNERSHIP_PERCENT_HIGH
OBJECT_VERSION_NUMBER
TREATMENT_NAME
DESCRIPTION