[Home] [Help]
View: GCS_NAT_ACCTS_V
Product: | GCS - Financial Consolidation Hub |
Description: | Natural account information. |
Implementation/DBA Data: |
APPS.GCS_NAT_ACCTS_V
|
View Text
SELECT FLIT.LINE_ITEM_ID
, FLIT.LINE_ITEM_NAME
, FLIT.LANGUAGE
, FLIT.SOURCE_LANG
FROM FEM_LN_ITEMS_TL FLIT
, GCS_SYSTEM_OPTIONS GSO
, FEM_GLOBAL_VS_COMBO_DEFS FGVCD
WHERE FLIT.VALUE_SET_ID = FGVCD.VALUE_SET_ID
AND FGVCD.DIMENSION_ID = 14
AND FGVCD.GLOBAL_VS_COMBO_ID = GSO.FCH_GLOBAL_VS_COMBO_ID
Columns
Name |
NATURAL_ACCOUNT_ID |
NAME |
LANGUAGE |
SOURCE_LANGUAGE |