APPS.INV_STATUS_PKG dependencies on MTL_SERIAL_NUMBERS

Line 45: MTL_SERIAL_NUMBERS msn

41:
42: select mms.status_code
43: into x_status_code
44: from mtl_material_statuses mms ,
45: MTL_SERIAL_NUMBERS msn
46: where mms.status_id = msn.status_id
47: and msn.SERIAL_NUMBER = p_serial
48: and msn.current_organization_id = p_org_id
49: and msn.inventory_item_id = p_item_id;

Line 194: FROM MTL_SERIAL_NUMBERS

190: * Add current status of resides in receiving
191: */
192: cursor serial_cur is
193: SELECT status_id
194: FROM MTL_SERIAL_NUMBERS
195: WHERE current_organization_id = p_org_id
196: AND inventory_item_id = p_item_id
197: --AND current_status in (1, 3, 5)
198: AND current_status in (1, 3, 5, 7)

Line 322: select msn.rowid FROM mtl_serial_numbers msn

318: )
319: FOR UPDATE NOWAIT;
320:
321: CURSOR cur_onhserial IS
322: select msn.rowid FROM mtl_serial_numbers msn
323: where inventory_item_id = Nvl(p_inventory_item_id, inventory_item_id)
324: and current_organization_id = p_organization_id
325: and current_subinventory_code = Nvl(p_sub_code, current_subinventory_code)
326: and nvl(current_locator_id, -9999) = nvl(p_locator_id, Nvl(current_locator_id, -9999))

Line 454: update mtl_serial_numbers

450: IF (l_debug = 1) THEN
451: mdebug('p_serial_status_id: '||p_serial_status_id);
452: END IF;
453: if p_serial_status_id >0 then
454: update mtl_serial_numbers
455: set status_id = p_serial_status_id
456: , last_updated_by = FND_GLOBAL.USER_ID
457: , last_update_date = SYSDATE
458: , last_update_login = FND_GLOBAL.LOGIN_ID

Line 537: UPDATE mtl_serial_numbers

533: AND locator_id = Nvl(p_locator_id ,-9999)
534: AND Nvl(lot_number,'@@@@') = Nvl(l_wlc_cur.lot_number,'@@@@')
535: AND lpn_id = l_wlc_cur.parent_lpn_id;
536: ELSIF(l_serial_status_enabled = 1)THEN
537: UPDATE mtl_serial_numbers
538: set status_id = p_onhand_status_id
539: , last_updated_by = FND_GLOBAL.USER_ID
540: , last_update_date = SYSDATE
541: , last_update_login = FND_GLOBAL.LOGIN_ID

Line 574: update mtl_serial_numbers

570: RETURN;
571: END IF;
572: END IF;
573:
574: update mtl_serial_numbers
575: set status_id = p_onhand_status_id
576: , last_updated_by = FND_GLOBAL.USER_ID
577: , last_update_date = SYSDATE
578: , last_update_login = FND_GLOBAL.LOGIN_ID

Line 636: update mtl_serial_numbers

632: OPEN cur_onhserial;
633: FETCH cur_onhserial BULK COLLECT INTO rowid_list1 ;
634: FORALL j in rowid_list1.first .. rowid_list1.last
635:
636: update mtl_serial_numbers
637: set status_id = p_onhand_status_id
638: , last_updated_by = FND_GLOBAL.USER_ID
639: , last_update_date = SYSDATE
640: , last_update_login = FND_GLOBAL.LOGIN_ID

Line 1182: FROM mtl_serial_numbers

1178: connect by parent_lpn_id = prior lpn_id
1179: );
1180: CURSOR msn_cur(l_inventory_item_id NUMBER,l_lpn_id NUMBER) is
1181: select status_id
1182: FROM mtl_serial_numbers
1183: where inventory_item_id = l_inventory_item_id
1184: AND lpn_id = l_lpn_id;
1185:
1186: l_serial_controlled NUMBER := 0;

Line 1327: FROM mtl_serial_numbers msn

1323: connect by parent_lpn_id = prior lpn_id
1324: );
1325: CURSOR msn_cur(l_inventory_item_id NUMBER,l_lpn_id NUMBER) is
1326: select status_id
1327: FROM mtl_serial_numbers msn
1328: where inventory_item_id = l_inventory_item_id
1329: AND lpn_id = l_lpn_id
1330: AND nvl(msn.lot_number , '@@@@') = NVL(p_lot_number,'@@@@')
1331: AND msn.serial_number NOT IN (select serial_number

Line 1332: from mtl_serial_numbers

1328: where inventory_item_id = l_inventory_item_id
1329: AND lpn_id = l_lpn_id
1330: AND nvl(msn.lot_number , '@@@@') = NVL(p_lot_number,'@@@@')
1331: AND msn.serial_number NOT IN (select serial_number
1332: from mtl_serial_numbers
1333: where serial_number between p_fm_sn AND p_to_sn);
1334:
1335: l_serial_controlled NUMBER := 0;
1336: l_serial_status_enabled NUMBER := 0;