APPS.INV_TRANSFER_ORDER_PVT dependencies on MTL_SYSTEM_ITEMS

Line 152: FROM mtl_system_items

148: l_primary_quantity NUMBER;
149: BEGIN
150: SELECT primary_uom_code
151: INTO l_primary_uom
152: FROM mtl_system_items
153: WHERE organization_id = p_organization_id
154: AND inventory_item_id = p_item_id;
155:
156: l_primary_quantity := inv_convert.inv_um_convert(item_id => p_item_id, lot_number => p_lot_number, organization_id => p_organization_id,

Line 296: FROM mtl_system_items_b

292:
293: -- nsinghi bug#5724815 Added new cursor to fetch the secondary uom code for item
294: CURSOR c_get_sec_uom IS
295: SELECT tracking_quantity_ind, secondary_uom_code
296: FROM mtl_system_items_b
297: WHERE inventory_item_id = p_item_id
298: AND organization_id = p_org_id;
299:
300: l_debug number;

Line 651: FROM mtl_system_items

647: SELECT lot_control_code
648: , serial_number_control_code
649: INTO l_lot_control_code
650: , l_serial_control_code
651: FROM mtl_system_items
652: WHERE inventory_item_id = l_troldt_tbl(l_counter).inventory_item_id
653: AND organization_id = l_troldt_tbl(l_counter).organization_id;
654:
655: IF (l_debug = 1) THEN

Line 2338: FROM mtl_system_items msi, mtl_Reservations mtr

2334: SELECT 1
2335: INTO l_ato_item
2336: FROM dual
2337: WHERE EXISTS (SELECT msi.inventory_item_id
2338: FROM mtl_system_items msi, mtl_Reservations mtr
2339: WHERE msi.inventory_item_id = mtr.inventory_item_id
2340: AND msi.organization_id = mtr.organization_id
2341: AND bom_item_type = 4
2342: AND replenish_to_order_flag = 'Y'

Line 2586: FROM mtl_system_items

2582:
2583: --INVCONV
2584: CURSOR get_item_details (l_org_id NUMBER, l_item_id NUMBER) IS
2585: SELECT primary_uom_code, secondary_uom_code, tracking_quantity_ind,secondary_default_ind
2586: FROM mtl_system_items
2587: WHERE inventory_item_id = l_item_id
2588: AND organization_id = l_org_id;
2589:
2590: /*Bug#12358448*/

Line 3476: FROM mtl_system_items

3472: , reservable_type
3473: INTO l_lot_control_code
3474: , l_serial_control_code
3475: , l_reservable_type_item
3476: FROM mtl_system_items
3477: WHERE inventory_item_id = l_mmtt_rec.inventory_item_id
3478: AND organization_id = l_mmtt_rec.organization_id;
3479:
3480: IF (l_debug = 1) THEN

Line 4362: FROM mtl_system_items

4358:
4359: --Bug 13961830 start,for indivisible item,update posting_flag to N,so that qty tree will not consider extra qty from the record in mmtt
4360: SELECT lot_divisible_flag
4361: INTO l_lot_divisible_flag
4362: FROM mtl_system_items
4363: WHERE inventory_item_id = l_mmtt_rec.inventory_item_id
4364: AND organization_id = l_mmtt_rec.organization_id;
4365: DEBUG('l_lot_divisible_flag:'||l_lot_divisible_flag,'Finalize_Pick_Confirm');
4366:

Line 5683: FROM mtl_system_items

5679: , reservable_type
5680: INTO l_lot_control_code
5681: , l_serial_control_code
5682: , l_reservable_type_item
5683: FROM mtl_system_items
5684: WHERE inventory_item_id = l_mmtt_rec.inventory_item_id
5685: AND organization_id = l_mmtt_rec.organization_id;
5686:
5687: IF (l_debug = 1) THEN