DBA Data[Home] [Help]

APPS.ENGPKIMP dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 1809: mtl_system_items_b_kfv f

1805: c.component_item_revision_id,
1806: c.obj_name,
1807: c.component_remarks
1808: from bom_components_b c, --bom_inventory_components c,
1809: mtl_system_items_b_kfv f
1810: where c.revised_item_sequence_id = revised_item
1811: AND c.bill_sequence_id = cp_bill_sequence_id -- R12: Added for common bom changes
1812: and f.inventory_item_id = c.component_item_id
1813: and f.organization_id = item.organization_id

Line 2946: mtl_system_items_b_kfv f

2942: a.substitute_component_id,
2943: f.concatenated_segments item_number
2944: FROM bom_substitute_components a,
2945: bom_inventory_components b,
2946: mtl_system_items_b_kfv f
2947: WHERE a.component_sequence_id = b.component_sequence_id
2948: and b.revised_item_sequence_id = revised_item
2949: and f.inventory_item_id = a.substitute_component_id
2950: -- and f.organization_id = item.organization_id