eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_STATUS_PKG dependencies on MTL_SERIAL_NUMBERS

Line 66: MTL_SERIAL_NUMBERS msn

62:
63: select mms.status_code
64: into x_status_code
65: from mtl_material_statuses mms ,
66: MTL_SERIAL_NUMBERS msn
67: where mms.status_id = msn.status_id
68: and msn.SERIAL_NUMBER = p_serial
69: and msn.current_organization_id = p_org_id
70: and msn.inventory_item_id = p_item_id;

Line 250: FROM MTL_SERIAL_NUMBERS

246: * Add current status of resides in receiving
247: */
248: cursor serial_cur is
249: SELECT status_id
250: FROM MTL_SERIAL_NUMBERS
251: WHERE current_organization_id = p_org_id
252: AND inventory_item_id = p_item_id
253: --AND current_status in (1, 3, 5)
254: AND current_status in (1, 3, 5, 7)

Line 337: select msn.rowid FROM mtl_serial_numbers msn,

333: FOR UPDATE NOWAIT;
334:
335:
336: CURSOR cur_onhserial IS
337: select msn.rowid FROM mtl_serial_numbers msn,
338: mtl_material_status_history mmsh
339: where msn.inventory_item_id = mmsh.inventory_item_id
340: and msn.current_organization_id = mmsh.organization_id
341: and msn.current_subinventory_code = mmsh.zone_code

Line 383: select msn.rowid FROM mtl_serial_numbers msn,

379: AND mmsh.status_update_id = p_transaction_id
380: FOR UPDATE NOWAIT;
381:
382: CURSOR cur_Serial IS
383: select msn.rowid FROM mtl_serial_numbers msn,
384: mtl_material_status_history mmsh
385: where msn.current_organization_id = mmsh.organization_id
386: and msn.inventory_item_id = mmsh.inventory_item_id
387: AND msn.serial_number = mmsh.serial_number

Line 442: update mtl_serial_numbers

438: FETCH cur_onhserial BULK COLLECT INTO rowid_list1 ;
439:
440: FORALL j in rowid_list1.first .. rowid_list1.last
441:
442: update mtl_serial_numbers
443: set status_id = p_status_id
444: , last_updated_by = FND_GLOBAL.USER_ID
445: , last_update_date = SYSDATE
446: , last_update_login = FND_GLOBAL.LOGIN_ID

Line 530: update mtl_serial_numbers

526: OPEN cur_Serial;
527: FETCH cur_Serial BULK COLLECT INTO rowid_list ;
528:
529: FORALL j in rowid_list.first .. rowid_list.last
530: update mtl_serial_numbers
531: set status_id = p_status_id
532: , last_updated_by = FND_GLOBAL.USER_ID
533: , last_update_date = SYSDATE
534: , last_update_login = FND_GLOBAL.LOGIN_ID

Line 660: select msn.rowid FROM mtl_serial_numbers msn

656: and nvl (p_to_lot_number, Nvl(lot_number, '@@@@'))
657: GROUP BY moqd.organization_id,moqd.inventory_item_id,moqd.subinventory_code,moqd.locator_id,moqd.lot_number,moqd.lpn_id;
658:
659: CURSOR cur_onhserial IS
660: select msn.rowid FROM mtl_serial_numbers msn
661: where inventory_item_id = Nvl(p_inventory_item_id, inventory_item_id)
662: and current_organization_id = p_organization_id
663: and current_subinventory_code = Nvl(p_sub_code, current_subinventory_code)
664: and nvl(current_locator_id, -9999) = nvl(p_locator_id, Nvl(current_locator_id, -9999))

Line 975: update mtl_serial_numbers

971:
972: --ERES Deferred
973:
974: IF p_pending_status = 0 THEN --ERES Deferred
975: update mtl_serial_numbers
976: set status_id = p_serial_status_id
977: , last_updated_by = FND_GLOBAL.USER_ID
978: , last_update_date = SYSDATE
979: , last_update_login = FND_GLOBAL.LOGIN_ID

Line 1060: UPDATE mtl_serial_numbers

1056: AND locator_id = Nvl(p_locator_id ,-9999)
1057: AND Nvl(lot_number,'@@@@') = Nvl(l_wlc_cur.lot_number,'@@@@')
1058: AND lpn_id = l_wlc_cur.parent_lpn_id;
1059: ELSIF(l_serial_status_enabled = 1)THEN
1060: UPDATE mtl_serial_numbers
1061: set status_id = p_onhand_status_id
1062: , last_updated_by = FND_GLOBAL.USER_ID
1063: , last_update_date = SYSDATE
1064: , last_update_login = FND_GLOBAL.LOGIN_ID

Line 1097: update mtl_serial_numbers

1093: RETURN;
1094: END IF;
1095: END IF;
1096:
1097: update mtl_serial_numbers
1098: set status_id = p_onhand_status_id
1099: , last_updated_by = FND_GLOBAL.USER_ID
1100: , last_update_date = SYSDATE
1101: , last_update_login = FND_GLOBAL.LOGIN_ID

Line 1282: update mtl_serial_numbers

1278: OPEN cur_onhserial;
1279: FETCH cur_onhserial BULK COLLECT INTO rowid_list1 ;
1280: FORALL j in rowid_list1.first .. rowid_list1.last
1281:
1282: update mtl_serial_numbers
1283: set status_id = p_onhand_status_id
1284: , last_updated_by = FND_GLOBAL.USER_ID
1285: , last_update_date = SYSDATE
1286: , last_update_login = FND_GLOBAL.LOGIN_ID

Line 1804: FROM mtl_serial_numbers

1800: connect by parent_lpn_id = prior lpn_id
1801: );
1802: CURSOR msn_cur(l_inventory_item_id NUMBER,l_lpn_id NUMBER) is
1803: select status_id
1804: FROM mtl_serial_numbers
1805: where inventory_item_id = l_inventory_item_id
1806: AND lpn_id = l_lpn_id;
1807:
1808: l_serial_controlled NUMBER := 0;

Line 1949: FROM mtl_serial_numbers msn

1945: connect by parent_lpn_id = prior lpn_id
1946: );
1947: CURSOR msn_cur(l_inventory_item_id NUMBER,l_lpn_id NUMBER) is
1948: select status_id
1949: FROM mtl_serial_numbers msn
1950: where inventory_item_id = l_inventory_item_id
1951: AND lpn_id = l_lpn_id
1952: AND nvl(msn.lot_number , '@@@@') = NVL(p_lot_number,'@@@@')
1953: AND msn.serial_number NOT IN (select serial_number

Line 1954: from mtl_serial_numbers

1950: where inventory_item_id = l_inventory_item_id
1951: AND lpn_id = l_lpn_id
1952: AND nvl(msn.lot_number , '@@@@') = NVL(p_lot_number,'@@@@')
1953: AND msn.serial_number NOT IN (select serial_number
1954: from mtl_serial_numbers
1955: where serial_number between p_fm_sn AND p_to_sn);
1956:
1957: l_serial_controlled NUMBER := 0;
1958: l_serial_status_enabled NUMBER := 0;