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 940: FROM mtl_system_items

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

Line 1028: FROM MTL_SYSTEM_ITEMS

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

Line 2004: FROM MTL_SYSTEM_ITEMS

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

Line 2470: FROM mrp_form_query mfq, mtl_system_items mtl

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

Line 2839: FROM MTL_SYSTEM_ITEMS

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

Line 4665: from mtl_system_items

4661: /*Changed the query to fetch variable_lead_time also for bug fix 7211657 */
4662:
4663: select NVL(fixed_lead_time,0)*l_working_time,NVL(variable_lead_time,0)*l_working_time
4664: into l_fixed_time,l_variable_time
4665: from mtl_system_items
4666: where organization_id = p_org_id
4667: and inventory_item_id = p_item_id;
4668:
4669: -- l_lead_time := l_fixed_time;