VIEW: APPS.GCS_ITEMS_TO_NAT_ACCTS_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)