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_ITEMS_TO_NAT_ACCTS_V

Product:	GCS - Financial Consolidation Hub (Obsolete)
Description:	Financial item to natural account relationship information.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT GHB.HIERARCHY_ID
, 1
, FLIB.LINE_ITEM_ID
FROM GCS_HIERARCHIES_B GHB
, FEM_LN_ITEMS_B FLIB
, GCS_SYSTEM_OPTIONS GSO
, FEM_GLOBAL_VS_COMBO_DEFS FGVCD
, FEM_OBJECT_DEFINITION_B ODB
WHERE GHB.CERTIFICATION_FLAG = 'Y'
AND 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 ODB.OBJECT_ID (+)= GSO.LN_ITEM_HIERARCHY_OBJ_ID
AND NOT EXISTS (SELECT 1
FROM FEM_LN_ITEMS_HIER LIH
WHERE LIH.HIERARCHY_OBJ_DEF_ID = ODB.OBJECT_DEFINITION_ID
AND LIH.PARENT_VALUE_SET_ID = FGVCD.VALUE_SET_ID
AND LIH.CHILD_VALUE_SET_ID = FGVCD.VALUE_SET_ID
AND LIH.CHILD_ID = FLIB.LINE_ITEM_ID
AND LIH.CHILD_ID <> LIH.PARENT_ID)

Columns

Name
FINANCIAL_STATEMENT_ID
FINANCIAL_ITEM_ID
NATURAL_ACCOUNT_ID