APPS.MRP_LINE_SCHEDULE_ALGORITHM dependencies on MTL_SYSTEM_ITEMS

Line 615: FROM mtl_system_items

611:
612: SELECT NVL(fixed_order_quantity,0), NVL(fixed_lot_multiplier,0),
613: NVL(minimum_order_quantity,0), NVL(maximum_order_quantity,0)
614: INTO v_fixed_qty, v_lot_multiple, v_min_qty, v_max_qty
615: FROM mtl_system_items
616: WHERE inventory_item_id = item_list_rec.primary_item_id
617: AND organization_id = p_org_id;
618:
619: V_ERROR_LINE := 2;

Line 939: FROM mtl_system_items

935: -- Find the round type of the item and populate into table.
936:
937: SELECT NVL(rounding_control_type,2)
938: INTO p_demand_tab(item_list_rec.primary_item_id).roundType
939: FROM mtl_system_items
940: WHERE inventory_item_id = item_list_rec.primary_item_id
941: AND organization_id = p_org_id;
942:
943: V_ERROR_LINE := 2;

Line 1027: FROM MTL_SYSTEM_ITEMS

1023: EXIT WHEN item_demand_cursor%NOTFOUND;
1024:
1025: SELECT NVL(fixed_lead_time, 0), NVL(variable_lead_time, 0)
1026: INTO v_fixed_lead_time, v_var_lead_time
1027: FROM MTL_SYSTEM_ITEMS
1028: WHERE inventory_item_id = v_item_id
1029: AND organization_id = p_org_id;
1030:
1031: p_item_demand_tab(i).item := v_item_id;

Line 2003: FROM MTL_SYSTEM_ITEMS

1999:
2000:
2001: SELECT NVL(fixed_lead_time, 0), NVL(variable_lead_time, 0)
2002: INTO l_fixed_lead_time, l_variable_lead_time
2003: FROM MTL_SYSTEM_ITEMS
2004: WHERE inventory_item_id = fs_select_rec.primary_item_id
2005: AND organization_id = p_org_id;
2006:
2007:

Line 2469: FROM mrp_form_query mfq, mtl_system_items mtl

2465:
2466: -- Cursor used to determine if any items of no rounding exists.
2467: CURSOR no_round_cursor IS
2468: SELECT number1,number2
2469: FROM mrp_form_query mfq, mtl_system_items mtl
2470: WHERE mfq.date1 = to_date(v_current_date,'J')
2471: AND mfq.query_id = v_query_id
2472: AND mfq.number1 = mtl.inventory_item_id
2473: AND NVL(mtl.rounding_control_type,2) <> C_ROUND_TYPE

Line 2838: FROM MTL_SYSTEM_ITEMS

2834:
2835:
2836: SELECT NVL(fixed_lead_time, 0), NVL(variable_lead_time, 0)
2837: INTO l_fixed_lead_time, l_variable_lead_time
2838: FROM MTL_SYSTEM_ITEMS
2839: WHERE inventory_item_id = fs_select_rec.primary_item_id
2840: AND organization_id = p_org_id;
2841:
2842:

Line 4658: from mtl_system_items

4654: /*Changed the query to fetch variable_lead_time also for bug fix 7211657 */
4655:
4656: select NVL(fixed_lead_time,0)*l_working_time,NVL(variable_lead_time,0)*l_working_time
4657: into l_fixed_time,l_variable_time
4658: from mtl_system_items
4659: where organization_id = p_org_id
4660: and inventory_item_id = p_item_id;
4661:
4662: -- l_lead_time := l_fixed_time;