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_CYC_SERIALS dependencies on MTL_SERIAL_NUMBERS

Line 40: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,

36: msn.lot_number,
37: 0,
38: msn.current_status,
39: mms.status_code
40: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
41: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce
42: WHERE msn.inventory_item_id = p_inventory_item_id
43: AND msn.current_organization_id = p_organization_id
44: AND msn.current_status IN (1, 3)

Line 60: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt,

56: AND mcce.entry_status_code IN (1, 3)
57: AND NVL(mcce.export_flag, 2) = 2
58: -- added for bug 13691739 starts
59: AND NOT EXISTS (SELECT 1
60: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt,
61: mtl_material_transactions_temp mmtt
62: WHERE mmtt.inventory_item_id = p_inventory_item_id
63: AND mmtt.organization_id = p_organization_id
64: AND mmtt.wms_task_status = 4

Line 97: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,

93: msn.lot_number,
94: 0,
95: msn.current_status,
96: mms.status_code
97: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
98: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce
99: WHERE msn.inventory_item_id = p_inventory_item_id
100: AND msn.group_mark_id = 1
101: AND msn.current_organization_id = p_organization_id

Line 119: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt,

115: AND NVL(mcce.export_flag, 2) = 2
116: AND NVL ( mcce.number_of_counts , 0 ) = NVL ( mcsn.number_of_counts , 0 ) -- Bug 4533713
117: -- added for bug 13691739 starts
118: AND NOT EXISTS (SELECT 1
119: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt,
120: mtl_material_transactions_temp mmtt
121: WHERE mmtt.inventory_item_id = p_inventory_item_id
122: AND mmtt.organization_id = p_organization_id
123: AND mmtt.wms_task_status = 4

Line 147: UPDATE mtl_serial_numbers

143: IS
144:
145: BEGIN
146: -- Multiple serial that are scheduled
147: UPDATE mtl_serial_numbers
148: SET group_mark_id = -1
149: WHERE inventory_item_id = p_inventory_item_id
150: AND current_organization_id = p_organization_id
151: AND serial_number IN

Line 153: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,

149: WHERE inventory_item_id = p_inventory_item_id
150: AND current_organization_id = p_organization_id
151: AND serial_number IN
152: (SELECT UNIQUE msn.serial_number
153: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
154: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce
155: WHERE msn.inventory_item_id = p_inventory_item_id
156: AND msn.current_organization_id = p_organization_id
157: AND msn.current_status IN (1, 3)

Line 173: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt,

169: AND mcce.entry_status_code IN (1, 3)
170: AND NVL(mcce.export_flag, 2) = 2
171: -- added for bug 13691739 starts
172: AND NOT EXISTS (SELECT 1
173: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt,
174: mtl_material_transactions_temp mmtt
175: WHERE mmtt.inventory_item_id = p_inventory_item_id
176: AND mmtt.organization_id = p_organization_id
177: AND mmtt.wms_task_status = 4

Line 214: FROM mtl_serial_numbers

210: INTO l_exist_temp
211: FROM DUAL
212: WHERE EXISTS
213: (SELECT 'multiple-serial'
214: FROM mtl_serial_numbers
215: WHERE inventory_item_id = p_inventory_item_id
216: AND current_organization_id = p_organization_id
217: AND serial_number IN
218: (SELECT UNIQUE msn.serial_number

Line 219: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,

215: WHERE inventory_item_id = p_inventory_item_id
216: AND current_organization_id = p_organization_id
217: AND serial_number IN
218: (SELECT UNIQUE msn.serial_number
219: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
220: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce
221: WHERE msn.inventory_item_id = p_inventory_item_id
222: AND msn.current_organization_id = p_organization_id
223: AND msn.current_status IN (1, 3, 4) -- For bug 14144558, added 4 in the list and commented below check

Line 241: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt,

237: AND mcce.entry_status_code IN (1, 3)
238: AND NVL(mcce.export_flag, 2) = 2
239: -- added for bug 13691739 starts
240: AND NOT EXISTS (SELECT 1
241: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt,
242: mtl_material_transactions_temp mmtt
243: WHERE mmtt.inventory_item_id = p_inventory_item_id
244: AND mmtt.organization_id = p_organization_id
245: AND mmtt.wms_task_status = 4

Line 257: UPDATE mtl_serial_numbers

253: print_debug('l_exist_temp = ' || l_exist_temp);
254:
255: IF (l_exist_temp <> 0) THEN
256: -- The serial number entry exists and can be marked
257: UPDATE mtl_serial_numbers
258: SET group_mark_id = 1
259: WHERE inventory_item_id = p_inventory_item_id
260: AND current_organization_id = p_organization_id
261: AND serial_number = p_serial_number;

Line 301: FROM mtl_serial_numbers

297: INTO l_exist_temp
298: FROM DUAL
299: WHERE EXISTS
300: (SELECT 'multiple-serial'
301: FROM mtl_serial_numbers
302: WHERE inventory_item_id = p_inventory_item_id
303: AND current_organization_id = p_organization_id
304: AND serial_number IN
305: (SELECT UNIQUE msn.serial_number

Line 306: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,

302: WHERE inventory_item_id = p_inventory_item_id
303: AND current_organization_id = p_organization_id
304: AND serial_number IN
305: (SELECT UNIQUE msn.serial_number
306: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
307: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce
308: WHERE msn.inventory_item_id = p_inventory_item_id
309: AND msn.current_organization_id = p_organization_id
310: AND msn.current_status IN (1, 3, 4) -- For bug 14144558, added 4 in the list

Line 328: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt,

324: AND mcce.entry_status_code IN (1, 3)
325: AND NVL(mcce.export_flag, 2) = 2
326: -- added for bug 13691739 starts
327: AND NOT EXISTS (SELECT 1
328: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt,
329: mtl_material_transactions_temp mmtt
330: WHERE mmtt.inventory_item_id = p_inventory_item_id
331: AND mmtt.organization_id = p_organization_id
332: AND mmtt.wms_task_status = 4

Line 342: UPDATE mtl_serial_numbers

338: ));
339:
340: IF (l_exist_temp <> 0) THEN
341: -- The serial number entry exists so unmark that serial number
342: UPDATE mtl_serial_numbers
343: SET group_mark_id = -1
344: WHERE inventory_item_id = p_inventory_item_id
345: AND current_organization_id = p_organization_id
346: AND serial_number = p_serial_number;

Line 372: UPDATE mtl_serial_numbers

368: IS
369:
370: BEGIN
371: -- Multiple serial that are scheduled
372: UPDATE mtl_serial_numbers
373: SET group_mark_id = 1
374: WHERE inventory_item_id = p_inventory_item_id
375: AND current_organization_id = p_organization_id
376: AND serial_number IN

Line 378: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,

374: WHERE inventory_item_id = p_inventory_item_id
375: AND current_organization_id = p_organization_id
376: AND serial_number IN
377: (SELECT UNIQUE msn.serial_number
378: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
379: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce
380: WHERE msn.inventory_item_id = p_inventory_item_id
381: AND msn.current_organization_id = p_organization_id
382: AND msn.current_status IN (1, 3)

Line 400: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt,

396: AND mcce.entry_status_code IN (1, 3)
397: AND NVL(mcce.export_flag, 2) = 2
398: -- added for bug 13691739 starts
399: AND NOT EXISTS (SELECT 1
400: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt,
401: mtl_material_transactions_temp mmtt
402: WHERE mmtt.inventory_item_id = p_inventory_item_id
403: AND mmtt.organization_id = p_organization_id
404: AND mmtt.wms_task_status = 4

Line 433: -- in the same sub/loc (based on columns in MTL_SERIAL_NUMBERS table) as the sub/loc

429: print_debug('Inside PROCEDURE mark_present_serials');
430:
431: -- Difference between this procedure and mark_all_present procedure defined above
432: -- Here we are Updating group_mark_id to 1 for only those serials which are
433: -- in the same sub/loc (based on columns in MTL_SERIAL_NUMBERS table) as the sub/loc
434: -- of the cycle count entry (based on column values in MTL_CYCLE_COUNT_ENTRIES table)
435:
436: UPDATE mtl_serial_numbers
437: SET group_mark_id = 1

Line 436: UPDATE mtl_serial_numbers

432: -- Here we are Updating group_mark_id to 1 for only those serials which are
433: -- in the same sub/loc (based on columns in MTL_SERIAL_NUMBERS table) as the sub/loc
434: -- of the cycle count entry (based on column values in MTL_CYCLE_COUNT_ENTRIES table)
435:
436: UPDATE mtl_serial_numbers
437: SET group_mark_id = 1
438: WHERE inventory_item_id = p_inventory_item_id
439: AND current_organization_id = p_organization_id
440: AND serial_number IN

Line 442: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,

438: WHERE inventory_item_id = p_inventory_item_id
439: AND current_organization_id = p_organization_id
440: AND serial_number IN
441: (SELECT UNIQUE msn.serial_number
442: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
443: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce
444: WHERE msn.inventory_item_id = p_inventory_item_id
445: AND msn.current_organization_id = p_organization_id
446: AND msn.current_status IN (1, 3)

Line 465: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt,

461: AND NVL(mcce.parent_lpn_id, -99999) = NVL(p_parent_lpn_id, -99999)
462: AND mcce.entry_status_code IN (1, 3)
463: AND NVL(mcce.export_flag, 2) = 2
464: AND NOT EXISTS (SELECT 1
465: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt,
466: mtl_material_transactions_temp mmtt
467: WHERE mmtt.inventory_item_id = p_inventory_item_id
468: AND mmtt.organization_id = p_organization_id
469: AND mmtt.wms_task_status = 4

Line 477: print_debug('Number of rows updated in MTL_SERIAL_NUMBERS: ' || SQL%ROWCOUNT);

473: AND msn.serial_number BETWEEN msnt.fm_serial_number AND msnt.to_serial_number
474: )
475: );
476:
477: print_debug('Number of rows updated in MTL_SERIAL_NUMBERS: ' || SQL%ROWCOUNT);
478:
479: END mark_present_serials;
480:
481:

Line 497: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,

493:
494: BEGIN
495: SELECT COUNT(*)
496: INTO x_number
497: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
498: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce
499: WHERE msn.inventory_item_id = p_inventory_item_id
500: AND msn.group_mark_id = 1
501: AND msn.current_organization_id = p_organization_id

Line 518: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt,

514: AND mcce.entry_status_code IN (1, 3)
515: AND NVL(mcce.export_flag, 2) = 2
516: -- added for bug 13691739 starts
517: AND NOT EXISTS (SELECT 1
518: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt,
519: mtl_material_transactions_temp mmtt
520: WHERE mmtt.inventory_item_id = p_inventory_item_id
521: AND mmtt.organization_id = p_organization_id
522: AND mmtt.wms_task_status = 4

Line 537: FROM mtl_Serial_numbers

533: l_temp_buf VARCHAR2(10);
534: BEGIN
535: SELECT 'exists'
536: INTO l_temp_buf
537: FROM mtl_Serial_numbers
538: WHERE serial_number = p_serial_number
539: AND inventory_item_id = p_inventory_item_id
540: AND current_organization_id = p_organization_id;
541:

Line 770: INSERT INTO MTL_SERIAL_NUMBERS (

766:
767: IF(exist_Serial_number(p_serial_number,p_inventory_item_id,p_organization_id) = FALSE) THEN
768: print_Debug('Serial number doesnt exist in msn ');
769: --Insert into MSN in case the serial number doesn't exist there.
770: INSERT INTO MTL_SERIAL_NUMBERS (
771: inventory_item_id,
772: serial_number,
773: last_update_date,
774: last_updated_by,

Line 957: Remove the serial numbers from mtl_cc_Serial_numbers and unmark the serials in mtl_serial_numbers

953: NULL;
954: END insert_Serial_number;
955:
956: /*Bug # 3646068
957: Remove the serial numbers from mtl_cc_Serial_numbers and unmark the serials in mtl_serial_numbers
958: for serials that have been entered till now */
959: PROCEDURE remove_serial_number
960: (p_cycle_count_header_id IN NUMBER,
961: p_organization_id IN NUMBER ,

Line 1011: --Unmark the serial number in mtl_Serial_numbers

1007: print_debug('Exception while trying to delete from mtl_cc_serial_numbers for serial ' || l_serial_number);
1008: END;
1009: END IF;
1010:
1011: --Unmark the serial number in mtl_Serial_numbers
1012: BEGIN
1013:
1014: UPDATE mtl_serial_numbers
1015: SET group_mark_id = NULL

Line 1014: UPDATE mtl_serial_numbers

1010:
1011: --Unmark the serial number in mtl_Serial_numbers
1012: BEGIN
1013:
1014: UPDATE mtl_serial_numbers
1015: SET group_mark_id = NULL
1016: WHERE serial_number = l_serial_number
1017: AND inventory_item_id = p_inventory_item_id
1018: AND current_organization_id = p_organization_id;