APPS.MRP_KANBAN_PLAN_PK dependencies on BOM_BILL_OF_MATERIALS

Line 940: bom_bill_of_materials bbom,

936: nvl(msi.fixed_order_quantity, nvl(msi.minimum_order_quantity, nvl(msi.maximum_order_quantity,1)))
937: FROM mtl_system_items msi,
938: mrp_low_level_codes mllc,
939: bom_inventory_components bic,
940: bom_bill_of_materials bbom,
941: bom_operational_routings bor,
942: mtl_parameters mp
943: WHERE mp.organization_id = g_kanban_info_rec.organization_id
944: AND bor.line_id (+) = p_line_id

Line 1513: bom_bill_of_materials bbom

1509: nvl(msi.fixed_order_quantity, nvl(msi.minimum_order_quantity, nvl(msi.maximum_order_quantity,1)))
1510: FROM mtl_system_items msi,
1511: mrp_low_level_codes mllc,
1512: bom_inventory_components bic,
1513: bom_bill_of_materials bbom
1514: WHERE
1515: bbom.assembly_item_id = p_assembly_item_id
1516: AND bbom.organization_id = g_kanban_info_rec.organization_id
1517: AND nvl(bbom.alternate_bom_designator, 'NONE') = nvl(p_top_alt, 'NONE')

Line 2014: bom_bill_of_materials bbom,

2010: nvl(msi.fixed_order_quantity, nvl(msi.minimum_order_quantity, nvl(msi.maximum_order_quantity,1)))
2011: FROM mtl_system_items msi,
2012: mrp_low_level_codes mllc,
2013: bom_inventory_components bic,
2014: bom_bill_of_materials bbom,
2015: bom_operational_routings bor,
2016: mtl_parameters mp
2017: WHERE mp.organization_id = g_kanban_info_rec.organization_id
2018: AND bor.line_id (+) = p_line_id