VIEW: APPS.GCS_HIERARCHIES_VL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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