DBA Data[Home] [Help]

APPS.ENGPKIMP dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 1902: mtl_system_items_b_kfv f

1898: f.replenish_to_order_flag, --BOM ER 9946990
1899: c.optional, --BOM ER 9946990
1900: c.component_remarks
1901: from bom_components_b c, --bom_inventory_components c,
1902: mtl_system_items_b_kfv f
1903: where c.revised_item_sequence_id = revised_item
1904: AND c.bill_sequence_id = cp_bill_sequence_id -- R12: Added for common bom changes
1905: and f.inventory_item_id = c.component_item_id
1906: and f.organization_id = item.organization_id

Line 3077: mtl_system_items_b_kfv f

3073: a.substitute_component_id,
3074: f.concatenated_segments item_number
3075: FROM bom_substitute_components a,
3076: bom_inventory_components b,
3077: mtl_system_items_b_kfv f
3078: WHERE a.component_sequence_id = b.component_sequence_id
3079: and b.revised_item_sequence_id = revised_item
3080: and f.inventory_item_id = a.substitute_component_id
3081: -- and f.organization_id = item.organization_id