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 3452: * from mtl_system_items

3448: *
3449: * -- Get primary UOM
3450: * select primary_uom_code
3451: * into l_primary_uom_code
3452: * from mtl_system_items
3453: * where organization_id = l_line_rec_org_id
3454: * and inventory_item_id = l_line_rec_inventory_item_id;
3455: *
3456: * -- Convert primary reservation quantity into

Line 4642: FROM mtl_system_items

4638: l_item_rec inv_reservation_global.item_record;
4639:
4640: CURSOR c_item(p_inventory_item_id NUMBER) IS
4641: SELECT *
4642: FROM mtl_system_items
4643: WHERE inventory_Item_Id = p_inventory_item_id;
4644:
4645: BEGIN
4646:

Line 5569: FROM mtl_system_items

5565: l_wip_job_type VARCHAR2(15);
5566: /*** End R12 }} ***/
5567: CURSOR c_item IS
5568: SELECT *
5569: FROM mtl_system_items
5570: WHERE inventory_Item_Id = p_orig_rsv_rec.inventory_item_id;
5571: BEGIN
5572: --
5573: -- First validate whether minimum number of arguments are provided for the