APPS.INV_TRANSFER_ORDER_PVT dependencies on MTL_SYSTEM_ITEMS

Line 150: FROM mtl_system_items

146: l_primary_quantity NUMBER;
147: BEGIN
148: SELECT primary_uom_code
149: INTO l_primary_uom
150: FROM mtl_system_items
151: WHERE organization_id = p_organization_id
152: AND inventory_item_id = p_item_id;
153:
154: l_primary_quantity := inv_convert.inv_um_convert(item_id => p_item_id, PRECISION => NULL, from_quantity => p_from_quantity, from_unit => p_from_unit, to_unit => l_primary_uom, from_name => NULL, to_name => NULL);

Line 293: FROM mtl_system_items_b

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

Line 648: FROM mtl_system_items

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

Line 2325: FROM mtl_system_items msi, mtl_Reservations mtr

2321: SELECT 1
2322: INTO l_ato_item
2323: FROM dual
2324: WHERE EXISTS (SELECT msi.inventory_item_id
2325: FROM mtl_system_items msi, mtl_Reservations mtr
2326: WHERE msi.inventory_item_id = mtr.inventory_item_id
2327: AND msi.organization_id = mtr.organization_id
2328: AND bom_item_type = 4
2329: AND replenish_to_order_flag = 'Y'

Line 2566: FROM mtl_system_items

2562:
2563: --INVCONV
2564: CURSOR get_item_details (l_org_id NUMBER, l_item_id NUMBER) IS
2565: SELECT primary_uom_code, secondary_uom_code, tracking_quantity_ind
2566: FROM mtl_system_items
2567: WHERE inventory_item_id = l_item_id
2568: AND organization_id = l_org_id;
2569: --INVCONV
2570: CURSOR lot_csr(l_trx_temp_id NUMBER) IS

Line 3249: FROM mtl_system_items

3245: , reservable_type
3246: INTO l_lot_control_code
3247: , l_serial_control_code
3248: , l_reservable_type_item
3249: FROM mtl_system_items
3250: WHERE inventory_item_id = l_mmtt_rec.inventory_item_id
3251: AND organization_id = l_mmtt_rec.organization_id;
3252:
3253: IF (l_debug = 1) THEN

Line 5302: FROM mtl_system_items

5298: , reservable_type
5299: INTO l_lot_control_code
5300: , l_serial_control_code
5301: , l_reservable_type_item
5302: FROM mtl_system_items
5303: WHERE inventory_item_id = l_mmtt_rec.inventory_item_id
5304: AND organization_id = l_mmtt_rec.organization_id;
5305:
5306: IF (l_debug = 1) THEN