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.SERIAL_CHECK dependencies on MTL_SERIAL_NUMBERS

Line 99: FROM mtl_serial_numbers

95: l_update_count NUMBER:= 0; /*** {{ R12 Enhanced reservations code changes ***/
96: l_hdr_id NUMBER;
97: CURSOR serial_lock1 IS
98: SELECT group_mark_id
99: FROM mtl_serial_numbers
100: WHERE current_organization_id = org_id
101: AND inventory_item_id = item_id
102: AND serial_number BETWEEN from_serial_number
103: AND to_serial_number

Line 109: FROM mtl_serial_numbers

105: FOR UPDATE OF group_mark_id NOWAIT;
106:
107: CURSOR serial_lock2 IS
108: SELECT group_mark_id
109: FROM mtl_serial_numbers
110: WHERE current_organization_id = org_id
111: AND inventory_item_id = item_id
112: AND serial_number = from_serial_number
113: FOR UPDATE OF group_mark_id NOWAIT;

Line 137: FROM mtl_serial_numbers

133: OPEN serial_lock1 ;
134:
135: SELECT COUNT(group_mark_id)
136: INTO marked_numbers_found
137: FROM mtl_serial_numbers
138: WHERE inventory_item_id = item_id
139: AND group_mark_id > 0
140: AND serial_number between from_serial_number
141: AND to_serial_number

Line 166: UPDATE mtl_serial_numbers

162: -- Since Serial Number S1 to S10 has status 4 (issued from Stores), user should be able
163: -- to chose S1 to S10 for receipt transaction to organization M2, even though the current
164: -- organization of serial S1 to S10 is M1.
165: */
166: UPDATE mtl_serial_numbers
167: SET lot_line_mark_id = lot_temp_id,
168: line_mark_id = temp_id,
169: group_mark_id = l_hdr_id,
170: reservation_id = nvl(p_reservation_id, reservation_id) /*** {{ R12 Enhanced reservations code changes ***/

Line 191: FROM mtl_serial_numbers

187: OPEN serial_lock2 ;
188:
189: SELECT COUNT(group_mark_id)
190: INTO marked_numbers_found
191: FROM mtl_serial_numbers
192: WHERE inventory_item_id = item_id
193: AND group_mark_id > 0
194: AND serial_number = from_serial_number ;
195: --BUG 2249383 Cannot have same item with serial number in different org

Line 218: UPDATE mtl_serial_numbers

214: -- to chose S1 to S10 for receipt transaction to organization M2, even though the current
215: -- organization of serial S1 to S10 is M1.
216: */
217:
218: UPDATE mtl_serial_numbers
219: SET lot_line_mark_id = lot_temp_id,
220: line_mark_id = temp_id,
221: group_mark_id = l_hdr_id,
222: reservation_id = nvl(p_reservation_id, reservation_id) /*** {{ R12 Enhanced reservations code changes ***/

Line 360: FROM mtl_serial_numbers

356:
357: CURSOR serial_rsv1 IS
358: SELECT reservation_id
359: , COUNT(reservation_id)
360: FROM mtl_serial_numbers
361: WHERE serial_number = from_serial_number AND
362: inventory_item_id = p_inventory_item_id AND
363: reservation_id IS NOT NULL
364: GROUP BY reservation_id;

Line 369: FROM mtl_serial_numbers

365:
366: CURSOR serial_rsv2 IS
367: SELECT reservation_id
368: , COUNT(reservation_id)
369: FROM mtl_serial_numbers
370: WHERE serial_number >= NVL(from_serial_number, serial_number) AND
371: serial_number <= NVL(to_serial_number, NVL(from_serial_number, serial_number) ) AND
372: inventory_item_id = p_inventory_item_id AND
373: reservation_id IS NOT NULL

Line 379: FROM mtl_serial_numbers

375:
376: CURSOR serial_rsv3 IS
377: SELECT reservation_id
378: , COUNT(reservation_id)
379: FROM mtl_serial_numbers
380: WHERE group_mark_id IN(hdr_id, lot_temp_id, temp_id) AND
381: (
382: line_mark_id = temp_id OR
383: line_mark_id IS NULL OR

Line 400: FROM mtl_serial_numbers

396:
397: CURSOR serial_rsv4 IS
398: SELECT reservation_id
399: , COUNT(reservation_id)
400: FROM mtl_serial_numbers
401: WHERE group_mark_id IN(hdr_id, temp_id) AND
402: (
403: line_mark_id = temp_id OR
404: line_mark_id IS NULL OR

Line 416: FROM mtl_serial_numbers

412:
413: CURSOR serial_rsv5 IS
414: SELECT reservation_id
415: , COUNT(reservation_id)
416: FROM mtl_serial_numbers
417: WHERE group_mark_id = hdr_id AND
418: serial_number >= NVL(from_serial_number, serial_number) AND
419: serial_number <= NVL(to_serial_number, NVL(from_serial_number, serial_number) ) AND
420: LENGTH(serial_number) = LENGTH(NVL(from_serial_number, serial_number) ) AND

Line 472: UPDATE mtl_serial_numbers

468: IF (p_update_reservation = fnd_api.g_true) THEN
469: IF (l_debug = 1) THEN
470: inv_log_util.TRACE('Case 1 and p_update_reservation is T', 'inv_unmark_rsv_serial');
471: END IF;
472: UPDATE mtl_serial_numbers
473: SET line_mark_id = unmarked_value
474: , group_mark_id = unmarked_value
475: , lot_line_mark_id = unmarked_value
476: , reservation_id = NULL /*** {{ R12 Enhanced reservations code changes ***/

Line 485: UPDATE mtl_serial_numbers

481: ELSE
482: IF (l_debug = 1) THEN
483: inv_log_util.TRACE('Case 1 and p_update_reservation it F', 'inv_unmark_rsv_serial');
484: END IF;
485: UPDATE mtl_serial_numbers
486: SET line_mark_id = unmarked_value
487: , group_mark_id = unmarked_value
488: , lot_line_mark_id = unmarked_value
489: WHERE serial_number = from_serial_number AND inventory_item_id = p_inventory_item_id;

Line 518: UPDATE mtl_serial_numbers

514: IF (p_update_reservation = fnd_api.g_true) THEN
515: IF (l_debug = 1) THEN
516: inv_log_util.TRACE('Case 2 and p_update_reservation it T', 'inv_unmark_rsv_serial');
517: END IF;
518: UPDATE mtl_serial_numbers
519: SET line_mark_id = unmarked_value
520: , group_mark_id = unmarked_value
521: , lot_line_mark_id = unmarked_value
522: , reservation_id = NULL /*** {{ R12 Enhanced reservations code changes ***/

Line 533: UPDATE mtl_serial_numbers

529: ELSE
530: IF (l_debug = 1) THEN
531: inv_log_util.TRACE('Case 2 and p_update_reservation it F', 'inv_unmark_rsv_serial');
532: END IF;
533: UPDATE mtl_serial_numbers
534: SET line_mark_id = unmarked_value
535: , group_mark_id = unmarked_value
536: , lot_line_mark_id = unmarked_value
537: WHERE serial_number >= NVL(from_serial_number, serial_number) AND

Line 574: UPDATE mtl_serial_numbers

570: IF (p_update_reservation = fnd_api.g_true) THEN
571: IF (l_debug = 1) THEN
572: inv_log_util.TRACE('Case 3 and p_update_reservation it T', 'inv_unmark_rsv_serial');
573: END IF;
574: UPDATE mtl_serial_numbers
575: SET line_mark_id = unmarked_value
576: , group_mark_id = unmarked_value
577: , lot_line_mark_id = unmarked_value
578: , reservation_id = NULL /*** {{ R12 Enhanced reservations code changes ***/

Line 597: UPDATE mtl_serial_numbers

593: ELSE
594: IF (l_debug = 1) THEN
595: inv_log_util.TRACE('Case 3 and p_update_reservation it F', 'inv_unmark_rsv_serial');
596: END IF;
597: UPDATE mtl_serial_numbers
598: SET line_mark_id = unmarked_value
599: , group_mark_id = unmarked_value
600: , lot_line_mark_id = unmarked_value
601: WHERE group_mark_id IN(hdr_id, lot_temp_id, temp_id) -- Bug 2491094: Added Temp ID also

Line 644: UPDATE mtl_serial_numbers

640: IF (p_update_reservation = fnd_api.g_true) THEN
641: IF (l_debug = 1) THEN
642: inv_log_util.TRACE('Case 4 and p_update_reservation it T', 'inv_unmark_rsv_serial');
643: END IF;
644: UPDATE mtl_serial_numbers
645: SET line_mark_id = unmarked_value
646: , group_mark_id = unmarked_value
647: , lot_line_mark_id = unmarked_value
648: , reservation_id = NULL /*** {{ R12 Enhanced reservations code changes ***/

Line 670: UPDATE mtl_serial_numbers

666: ELSE
667: IF (l_debug = 1) THEN
668: inv_log_util.TRACE('Case 4 and p_update_reservation it F', 'inv_unmark_rsv_serial');
669: END IF;
670: UPDATE mtl_serial_numbers
671: SET line_mark_id = unmarked_value
672: , group_mark_id = unmarked_value
673: , lot_line_mark_id = unmarked_value
674: WHERE group_mark_id IN(hdr_id, temp_id) AND

Line 715: UPDATE mtl_serial_numbers

711: IF (p_update_reservation = fnd_api.g_true) THEN
712: IF (l_debug = 1) THEN
713: inv_log_util.TRACE('Case 5 and p_update_reservation it T', 'inv_unmark_rsv_serial');
714: END IF;
715: UPDATE mtl_serial_numbers
716: SET line_mark_id = unmarked_value
717: , group_mark_id = unmarked_value
718: , lot_line_mark_id = unmarked_value
719: , reservation_id = NULL /*** {{ R12 Enhanced reservations code changes ***/

Line 731: UPDATE mtl_serial_numbers

727: ELSE
728: IF (l_debug = 1) THEN
729: inv_log_util.TRACE('Case 5 and p_update_reservation it F', 'inv_unmark_rsv_serial');
730: END IF;
731: UPDATE mtl_serial_numbers
732: SET line_mark_id = unmarked_value
733: , group_mark_id = unmarked_value
734: , lot_line_mark_id = unmarked_value
735: WHERE group_mark_id = hdr_id AND

Line 807: UPDATE mtl_serial_numbers

803: inv_log_util.trace('to_serial_number is null or same as from_serial_number','SERIAL_CHECK');
804: END IF;
805:
806: BEGIN
807: UPDATE mtl_serial_numbers
808: --SET group_mark_id = nvl(temp_id, hdr_id)
809: --rtv enhancement
810: SET group_mark_id = Nvl(hdr_id,temp_id)
811: ,line_mark_id = Decode(hdr_id,NULL,NULL,temp_id)

Line 832: UPDATE mtl_serial_numbers

828: inv_log_util.trace('to_serial_number not null and different from from_serial_number','SERIAL_CHECK');
829: END IF;
830:
831: BEGIN
832: UPDATE mtl_serial_numbers
833: --SET group_mark_id = nvl(temp_id, hdr_id)
834: --rtv enhancement
835: SET group_mark_id = Nvl(hdr_id,temp_id)
836: ,line_mark_id = Decode(hdr_id,NULL,NULL,temp_id)