[Home] [Help]
View: GCS_HIERARCHIES_VL
Product: | GCS - Financial Consolidation Hub |
Description: | Consolidation hierarchy information |
Implementation/DBA Data: |
APPS.GCS_HIERARCHIES_VL
|
View Text
SELECT B.HIERARCHY_ID
, B.TOP_ENTITY_ID
, B.START_DATE
, B.CALENDAR_ID
, B.DIMENSION_GROUP_ID
, B.IE_BY_ORG_CODE
, B.BALANCE_BY_ORG_FLAG
, B.ENABLED_FLAG
, B.THRESHOLD_AMOUNT
, B.THRESHOLD_CURRENCY
, B.FEM_LEDGER_ID
, B.COLUMN_NAME
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.OBJECT_VERSION_NUMBER
, TL.HIERARCHY_NAME
, TL.DESCRIPTION
, B.SECURITY_ENABLED_FLAG
, B.CERTIFICATION_FLAG
, B.LOB_REPORTING_ENABLED_FLAG
, B.LOB_HIERARCHY_OBJ_ID
, B.LOB_DIM_COLUMN_NAME
, B.HIERARCHY_GRP_FLAG
FROM GCS_HIERARCHIES_B B
, GCS_HIERARCHIES_TL TL
WHERE B.HIERARCHY_ID = TL.HIERARCHY_ID
AND TL.LANGUAGE = USERENV('LANG')
Columns
Name |
HIERARCHY_ID |
TOP_ENTITY_ID |
START_DATE |
CALENDAR_ID |
DIMENSION_GROUP_ID |
IE_BY_ORG_CODE |
BALANCE_BY_ORG_FLAG |
ENABLED_FLAG |
THRESHOLD_AMOUNT |
THRESHOLD_CURRENCY |
FEM_LEDGER_ID |
COLUMN_NAME |
CREATION_DATE |
CREATED_BY |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |
OBJECT_VERSION_NUMBER |
HIERARCHY_NAME |
DESCRIPTION |
SECURITY_ENABLED_FLAG |
CERTIFICATION_FLAG |
LOB_REPORTING_ENABLED_FLAG |
LOB_HIERARCHY_OBJ_ID |
LOB_DIM_COLUMN_NAME |
HIERARCHY_GRP_FLAG |