VIEW: APPS.GCS_NAT_ACCTS_HIER_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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