DBA Data[Home] [Help]

VIEW: APPS.GCS_NAT_ACCTS_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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