DBA Data[Home] [Help]

APPS.MRP_KANBAN_PLAN_PK dependencies on BOM_BILL_OF_MATERIALS

Line 877: bom_bill_of_materials bbom,

873: nvl(msi.fixed_order_quantity, nvl(msi.minimum_order_quantity, nvl(msi.maximum_order_quantity,1)))
874: FROM mtl_system_items msi,
875: mrp_low_level_codes mllc,
876: bom_inventory_components bic,
877: bom_bill_of_materials bbom,
878: bom_operational_routings bor,
879: mtl_parameters mp
880: WHERE mp.organization_id = g_kanban_info_rec.organization_id
881: AND bor.line_id (+) = p_line_id

Line 1434: bom_bill_of_materials bbom

1430: nvl(msi.fixed_order_quantity, nvl(msi.minimum_order_quantity, nvl(msi.maximum_order_quantity,1)))
1431: FROM mtl_system_items msi,
1432: mrp_low_level_codes mllc,
1433: bom_inventory_components bic,
1434: bom_bill_of_materials bbom
1435: WHERE
1436: bbom.assembly_item_id = p_assembly_item_id
1437: AND bbom.organization_id = g_kanban_info_rec.organization_id
1438: AND nvl(bbom.alternate_bom_designator, 'NONE') = nvl(p_top_alt, 'NONE')

Line 1919: bom_bill_of_materials bbom,

1915: nvl(msi.fixed_order_quantity, nvl(msi.minimum_order_quantity, nvl(msi.maximum_order_quantity,1)))
1916: FROM mtl_system_items msi,
1917: mrp_low_level_codes mllc,
1918: bom_inventory_components bic,
1919: bom_bill_of_materials bbom,
1920: bom_operational_routings bor,
1921: mtl_parameters mp
1922: WHERE mp.organization_id = g_kanban_info_rec.organization_id
1923: AND bor.line_id (+) = p_line_id