[Home] [Help]
910: -- cursor component_cursor1 is the cursor that passes down demand
911: -- to the components feeding into a line. Notice that we are driving
912: -- off of bom_operational_routings
913: -- also if supply sub and locator are null in bom_inventory_components
914: -- we get it from wip supply locations from mtl_system_items - this
915: -- is ok for R-11, though we might have an issue here for R12
916:
917: CURSOR component_cursor1 IS
918: SELECT DISTINCT
933: /* Added for lot based material support. Need to query wip_supply_type, basis_type and fixed_order_qty */
934: mllc.wip_supply_type,
935: mllc.basis_type,
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,
1022: /* Added for lot based material support. Need to query wip_supply_type, basis_type and fixed_order_qty */
1023: mllc.wip_supply_type,
1024: mllc.basis_type,
1025: nvl(msi.fixed_order_quantity, nvl(msi.minimum_order_quantity, nvl(msi.maximum_order_quantity,1)))
1026: FROM mtl_system_items msi,
1027: mrp_low_level_codes mllc
1028: WHERE mllc.plan_id = g_kanban_info_rec.kanban_plan_id
1029: AND mllc.organization_id + 0 = g_kanban_info_rec.organization_id
1030: AND mllc.assembly_item_id = p_assembly_item_id
1483: -- cursor component_cursor1 is the cursor that passes down demand
1484: -- to the components feeding into a line. Notice that we are driving
1485: -- off of bom_operational_routings
1486: -- also if supply sub and locator are null in bom_inventory_components
1487: -- we get it from wip supply locations from mtl_system_items - this
1488: -- is ok for R-11, though we might have an issue here for R12
1489:
1490: CURSOR component_cursor1 IS
1491: SELECT DISTINCT
1506: /* Added for lot based material support. Need to query wip_supply_type, basis_type and fixed_order_qty */
1507: mllc.wip_supply_type,
1508: mllc.basis_type,
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
1591: /* Added for lot based material support. Need to query wip_supply_type, basis_type and fixed_order_qty */
1592: mllc.wip_supply_type,
1593: mllc.basis_type,
1594: nvl(msi.fixed_order_quantity, nvl(msi.minimum_order_quantity, nvl(msi.maximum_order_quantity,1)))
1595: FROM mtl_system_items msi,
1596: mrp_low_level_codes mllc
1597: WHERE mllc.plan_id = g_kanban_info_rec.kanban_plan_id
1598: AND mllc.organization_id + 0 = g_kanban_info_rec.organization_id
1599: AND mllc.assembly_item_id = p_assembly_item_id
1984: -- cursor component_cursor1 is the cursor that passes down demand
1985: -- to the components feeding into a line. Notice that we are driving
1986: -- off of bom_operational_routings
1987: -- also if supply sub and locator are null in bom_inventory_components
1988: -- we get it from wip supply locations from mtl_system_items - this
1989: -- is ok for R-11, though we might have an issue here for R12
1990:
1991: CURSOR component_cursor1 IS
1992: SELECT DISTINCT
2007: /* Added for lot based material support. Need to query wip_supply_type, basis_type and fixed_order_qty */
2008: mllc.wip_supply_type,
2009: mllc.basis_type,
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,
2096: /* Added for lot based material support. Need to query wip_supply_type, basis_type and fixed_order_qty */
2097: mllc.wip_supply_type,
2098: mllc.basis_type,
2099: nvl(msi.fixed_order_quantity, nvl(msi.minimum_order_quantity, nvl(msi.maximum_order_quantity,1)))
2100: FROM mtl_system_items msi,
2101: mrp_low_level_codes mllc
2102: WHERE mllc.plan_id = g_kanban_info_rec.kanban_plan_id
2103: AND mllc.organization_id + 0 = g_kanban_info_rec.organization_id
2104: AND mllc.assembly_item_id = p_assembly_item_id
2741: SELECT bom_item_type,
2742: nvl(fixed_order_quantity, nvl(minimum_order_quantity, nvl(maximum_order_quantity,1)))
2743: INTO l_bom_item_type,
2744: l_foq
2745: FROM mtl_system_items
2746: WHERE inventory_item_id = p_inventory_item_id
2747: AND organization_id = g_kanban_info_rec.organization_id;
2748: -- Bug Fix 10366202.
2749: IF p_demand_type = 1 OR p_demand_type = 2 OR l_bom_item_type = 4 THEN
3057: SELECT bom_item_type,
3058: nvl(fixed_order_quantity, nvl(minimum_order_quantity, nvl(maximum_order_quantity,1)))
3059: INTO l_bom_item_type,
3060: l_foq
3061: FROM mtl_system_items
3062: WHERE inventory_item_id = p_inventory_item_id
3063: AND organization_id = g_kanban_info_rec.organization_id;
3064:
3065: l_explode_always := 'Y';
3375: SELECT bom_item_type,
3376: nvl(fixed_order_quantity, nvl(minimum_order_quantity, nvl(maximum_order_quantity,1)))
3377: INTO l_bom_item_type,
3378: l_foq
3379: FROM mtl_system_items
3380: WHERE inventory_item_id = p_inventory_item_id
3381: AND organization_id = g_kanban_info_rec.organization_id;
3382:
3383: IF p_demand_type = 1 OR l_bom_item_type = 4 THEN