APPS.MRP_KANBAN_PLAN_PK dependencies on MTL_SYSTEM_ITEMS

Line 851: -- we get it from wip supply locations from mtl_system_items - this

847: -- cursor component_cursor1 is the cursor that passes down demand
848: -- to the components feeding into a line. Notice that we are driving
849: -- off of bom_operational_routings
850: -- also if supply sub and locator are null in bom_inventory_components
851: -- we get it from wip supply locations from mtl_system_items - this
852: -- is ok for R-11, though we might have an issue here for R12
853:
854: CURSOR component_cursor1 IS
855: SELECT DISTINCT

Line 874: FROM mtl_system_items msi,

870: /* Added for lot based material support. Need to query wip_supply_type, basis_type and fixed_order_qty */
871: mllc.wip_supply_type,
872: mllc.basis_type,
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,

Line 963: FROM mtl_system_items msi,

959: /* Added for lot based material support. Need to query wip_supply_type, basis_type and fixed_order_qty */
960: mllc.wip_supply_type,
961: mllc.basis_type,
962: nvl(msi.fixed_order_quantity, nvl(msi.minimum_order_quantity, nvl(msi.maximum_order_quantity,1)))
963: FROM mtl_system_items msi,
964: mrp_low_level_codes mllc
965: WHERE mllc.plan_id = g_kanban_info_rec.kanban_plan_id
966: AND mllc.organization_id + 0 = g_kanban_info_rec.organization_id
967: AND mllc.assembly_item_id = p_assembly_item_id

Line 1408: -- we get it from wip supply locations from mtl_system_items - this

1404: -- cursor component_cursor1 is the cursor that passes down demand
1405: -- to the components feeding into a line. Notice that we are driving
1406: -- off of bom_operational_routings
1407: -- also if supply sub and locator are null in bom_inventory_components
1408: -- we get it from wip supply locations from mtl_system_items - this
1409: -- is ok for R-11, though we might have an issue here for R12
1410:
1411: CURSOR component_cursor1 IS
1412: SELECT DISTINCT

Line 1431: FROM mtl_system_items msi,

1427: /* Added for lot based material support. Need to query wip_supply_type, basis_type and fixed_order_qty */
1428: mllc.wip_supply_type,
1429: mllc.basis_type,
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

Line 1516: FROM mtl_system_items msi,

1512: /* Added for lot based material support. Need to query wip_supply_type, basis_type and fixed_order_qty */
1513: mllc.wip_supply_type,
1514: mllc.basis_type,
1515: nvl(msi.fixed_order_quantity, nvl(msi.minimum_order_quantity, nvl(msi.maximum_order_quantity,1)))
1516: FROM mtl_system_items msi,
1517: mrp_low_level_codes mllc
1518: WHERE mllc.plan_id = g_kanban_info_rec.kanban_plan_id
1519: AND mllc.organization_id + 0 = g_kanban_info_rec.organization_id
1520: AND mllc.assembly_item_id = p_assembly_item_id

Line 1893: -- we get it from wip supply locations from mtl_system_items - this

1889: -- cursor component_cursor1 is the cursor that passes down demand
1890: -- to the components feeding into a line. Notice that we are driving
1891: -- off of bom_operational_routings
1892: -- also if supply sub and locator are null in bom_inventory_components
1893: -- we get it from wip supply locations from mtl_system_items - this
1894: -- is ok for R-11, though we might have an issue here for R12
1895:
1896: CURSOR component_cursor1 IS
1897: SELECT DISTINCT

Line 1916: FROM mtl_system_items msi,

1912: /* Added for lot based material support. Need to query wip_supply_type, basis_type and fixed_order_qty */
1913: mllc.wip_supply_type,
1914: mllc.basis_type,
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,

Line 2005: FROM mtl_system_items msi,

2001: /* Added for lot based material support. Need to query wip_supply_type, basis_type and fixed_order_qty */
2002: mllc.wip_supply_type,
2003: mllc.basis_type,
2004: nvl(msi.fixed_order_quantity, nvl(msi.minimum_order_quantity, nvl(msi.maximum_order_quantity,1)))
2005: FROM mtl_system_items msi,
2006: mrp_low_level_codes mllc
2007: WHERE mllc.plan_id = g_kanban_info_rec.kanban_plan_id
2008: AND mllc.organization_id + 0 = g_kanban_info_rec.organization_id
2009: AND mllc.assembly_item_id = p_assembly_item_id

Line 2567: FROM mtl_system_items

2563: SELECT bom_item_type,
2564: nvl(fixed_order_quantity, nvl(minimum_order_quantity, nvl(maximum_order_quantity,1)))
2565: INTO l_bom_item_type,
2566: l_foq
2567: FROM mtl_system_items
2568: WHERE inventory_item_id = p_inventory_item_id
2569: AND organization_id = g_kanban_info_rec.organization_id;
2570:
2571: IF p_demand_type = 1 OR l_bom_item_type = 4 THEN

Line 2812: FROM mtl_system_items

2808: SELECT bom_item_type,
2809: nvl(fixed_order_quantity, nvl(minimum_order_quantity, nvl(maximum_order_quantity,1)))
2810: INTO l_bom_item_type,
2811: l_foq
2812: FROM mtl_system_items
2813: WHERE inventory_item_id = p_inventory_item_id
2814: AND organization_id = g_kanban_info_rec.organization_id;
2815:
2816: l_explode_always := 'Y';

Line 3057: FROM mtl_system_items

3053: SELECT bom_item_type,
3054: nvl(fixed_order_quantity, nvl(minimum_order_quantity, nvl(maximum_order_quantity,1)))
3055: INTO l_bom_item_type,
3056: l_foq
3057: FROM mtl_system_items
3058: WHERE inventory_item_id = p_inventory_item_id
3059: AND organization_id = g_kanban_info_rec.organization_id;
3060:
3061: IF p_demand_type = 1 OR l_bom_item_type = 4 THEN