APPS.EGO_ITEM_WS_PVT dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 1883: FROM bom_explosions_all be , mtl_system_items_b_kfv ego

1879: ,ego.organization_id AS org_id
1880: ,bom_exploder_pub.get_component_revision_id(nvl(be.component_sequence_id, 0)) AS rev_id
1881: , bom_exploder_pub.get_component_revision_label(nvl(be.component_sequence_id, 0)) AS rev_label
1882: , be.plan_level AS plan_level
1883: FROM bom_explosions_all be , mtl_system_items_b_kfv ego
1884: WHERE be.group_id = grp_id
1885: AND ego.inventory_item_id = be.component_item_id
1886: AND ego.organization_id = be.organization_id
1887: AND be.plan_level <= levels

Line 4705: l_component_name mtl_system_items_b_kfv.CONCATENATED_SEGMENTS%TYPE;

4701: l_user_name VARCHAR2(100);
4702: l_structure_name VARCHAR2(100);
4703: p_index number;
4704: l_seq_number NUMBER;
4705: l_component_name mtl_system_items_b_kfv.CONCATENATED_SEGMENTS%TYPE;
4706:
4707: TYPE DYNAMIC_CUR IS REF CURSOR;
4708: v_dynamic_cursor DYNAMIC_CUR;
4709:

Line 4844: from mtl_system_items_b_kfv

4840: EXIT WHEN v_dynamic_cursor%NOTFOUND;
4841:
4842: select CONCATENATED_SEGMENTS
4843: into l_component_name
4844: from mtl_system_items_b_kfv
4845: WHERE inventory_item_id = l_item_id
4846: AND ORGANIZATION_ID = l_org_id;
4847:
4848: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,

Line 4895: from mtl_system_items_b_kfv

4891: AND SEQUENCE_NUMBER IS NULL)
4892: loop
4893: select CONCATENATED_SEGMENTS
4894: into l_component_name
4895: from mtl_system_items_b_kfv
4896: WHERE inventory_item_id = i.PK1_VALUE
4897: AND ORGANIZATION_ID = i.PK2_VALUE;
4898:
4899: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,