View: GCS_NAT_ACCTS_HIER_V

Product:	GCS - Financial Consolidation Hub
Description:	Natural account hierarchy information.
Implementation/DBA Data:	APPS.GCS_NAT_ACCTS_HIER_V

View Text

SELECT FLIB.LINE_ITEM_ID
, FLIB.LINE_ITEM_DISPLAY_CODE
, FLIH.PARENT_ID
FROM FEM_LN_ITEMS_B FLIB
, GCS_SYSTEM_OPTIONS GSO
, FEM_GLOBAL_VS_COMBO_DEFS FGVCD
, (SELECT FLIH.CHILD_VALUE_SET_ID
, FLIH.CHILD_ID
, FLIH.PARENT_ID
FROM FEM_LN_ITEMS_HIER FLIH
, FEM_OBJECT_DEFINITION_B ODB
, GCS_SYSTEM_OPTIONS GSO_INNER
WHERE FLIH.CHILD_ID <> FLIH.PARENT_ID
AND FLIH.CHILD_VALUE_SET_ID = FLIH.PARENT_VALUE_SET_ID
AND FLIH.HIERARCHY_OBJ_DEF_ID = ODB.OBJECT_DEFINITION_ID
AND ODB.OBJECT_ID = GSO_INNER.LN_ITEM_HIERARCHY_OBJ_ID
AND FLIH.SINGLE_DEPTH_FLAG = 'Y') FLIH
WHERE FLIB.VALUE_SET_ID = FGVCD.VALUE_SET_ID
AND FGVCD.DIMENSION_ID = 14
AND FGVCD.GLOBAL_VS_COMBO_ID = GSO.FCH_GLOBAL_VS_COMBO_ID
AND FLIH.CHILD_ID (+)= FLIB.LINE_ITEM_ID
AND FLIH.CHILD_VALUE_SET_ID (+)= FLIB.VALUE_SET_ID

Columns