DBA Data[Home] [Help]

APPS.EGO_ITEM_WS_PVT dependencies on BOM_EXPLOSIONS_ALL

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