APPS.INV_RESERVATION_VALIDATE_PVT dependencies on MTL_SYSTEM_ITEMS

Line 131: -- 2. p_inventory_item_id is in mtl_system_items table

127: -- validate_item
128: -- Description
129: -- is valid if all of the following are satisfied
130: -- 1. p_inventory_item_id is not null
131: -- 2. p_inventory_item_id is in mtl_system_items table
132: PROCEDURE validate_item
133: (
134: x_return_status OUT NOCOPY VARCHAR2
135: , p_inventory_item_id IN NUMBER

Line 185: mtl_system_items

181: , location_control_code
182: , primary_uom_code
183: INTO l_rec
184: FROM
185: mtl_system_items
186: WHERE
187: inventory_item_id = p_inventory_item_id
188: AND organization_id = p_organization_id ;
189: EXCEPTION

Line 834: FROM mtl_system_items

830: END IF;
831:
832: SELECT replenish_to_order_flag
833: INTO l_replenish_to_order
834: FROM mtl_system_items
835: WHERE organization_id = p_organization_id
836: AND inventory_item_id = p_inventory_item_id;
837:
838: IF (l_debug = 1) THEN

Line 1179: FROM mtl_system_items

1175: END IF;
1176:
1177: SELECT replenish_to_order_flag
1178: INTO l_replenish_to_order
1179: FROM mtl_system_items
1180: WHERE organization_id = p_organization_id
1181: AND inventory_item_id = p_inventory_item_id;
1182:
1183: IF (l_debug = 1) THEN

Line 1308: FROM mtl_system_items

1304: END IF;
1305:
1306: SELECT replenish_to_order_flag
1307: INTO l_replenish_to_order
1308: FROM mtl_system_items
1309: WHERE organization_id = p_organization_id
1310: AND inventory_item_id = p_inventory_item_id;
1311:
1312: IF (l_debug = 1) THEN

Line 1437: FROM mtl_system_items

1433: END IF;
1434:
1435: SELECT replenish_to_order_flag
1436: INTO l_replenish_to_order
1437: FROM mtl_system_items
1438: WHERE organization_id = p_organization_id
1439: AND inventory_item_id = p_inventory_item_id;
1440:
1441: IF (l_debug = 1) THEN

Line 3288: * from mtl_system_items

3284: *
3285: * -- Get primary UOM
3286: * select primary_uom_code
3287: * into l_primary_uom_code
3288: * from mtl_system_items
3289: * where organization_id = l_line_rec_org_id
3290: * and inventory_item_id = l_line_rec_inventory_item_id;
3291: *
3292: * -- Convert primary reservation quantity into

Line 4478: FROM mtl_system_items

4474: l_item_rec inv_reservation_global.item_record;
4475:
4476: CURSOR c_item(p_inventory_item_id NUMBER) IS
4477: SELECT *
4478: FROM mtl_system_items
4479: WHERE inventory_Item_Id = p_inventory_item_id;
4480:
4481: BEGIN
4482:

Line 5405: FROM mtl_system_items

5401: l_wip_job_type VARCHAR2(15);
5402: /*** End R12 }} ***/
5403: CURSOR c_item IS
5404: SELECT *
5405: FROM mtl_system_items
5406: WHERE inventory_Item_Id = p_orig_rsv_rec.inventory_item_id;
5407: BEGIN
5408: --
5409: -- First validate whether minimum number of arguments are provided for the