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

Line 2413: FROM mtl_serial_numbers

2409: FOR i in 1..p_serial_number_tbl.count LOOP
2410: BEGIN
2411: SELECT reservation_id, serial_number
2412: INTO x_serial_number_tbl(l_index).reservation_id, x_serial_number_tbl(l_index).serial_number
2413: FROM mtl_serial_numbers
2414: WHERE serial_number = p_serial_number_tbl(i).serial_number
2415: AND inventory_item_id = p_serial_number_tbl(i).inventory_item_id
2416: AND reservation_id is not null;
2417: l_index := l_index + 1;

Line 2563: FROM mtl_serial_numbers

2559: FOR i in 1..p_serial_number_tbl.count LOOP
2560: BEGIN
2561: SELECT reservation_id, serial_number
2562: INTO x_serial_number_tbl(l_index).reservation_id, x_serial_number_tbl(l_index).serial_number
2563: FROM mtl_serial_numbers
2564: WHERE serial_number = p_serial_number_tbl(i).serial_number
2565: AND inventory_item_id = p_serial_number_tbl(i).inventory_item_id
2566: AND reservation_id is not null;
2567:

Line 7546: l_serial_number_table FROM mtl_serial_numbers

7542: IF (l_debug=1) THEN
7543: debug_print('Count. i: '|| i);
7544: END IF;
7545: SELECT reservation_id, serial_number bulk collect INTO
7546: l_serial_number_table FROM mtl_serial_numbers
7547: WHERE reservation_id = l_mtl_reservation_tbl(i).reservation_id;
7548: EXCEPTION
7549: WHEN no_data_found THEN
7550: IF l_debug=1 THEN

Line 7576: mtl_serial_numbers WHERE serial_number = l_serial_number AND

7572: debug_print('Count. Serial index: '|| l_serial_table_index);
7573: END IF;
7574:
7575: SELECT reservation_id INTO l_reservation_id FROM
7576: mtl_serial_numbers WHERE serial_number = l_serial_number AND
7577: current_organization_id = l_mtl_reservation_tbl(l_serial_table_index).organization_id AND
7578: inventory_item_id = l_mtl_reservation_tbl(l_serial_table_index).inventory_item_id;
7579:
7580: EXCEPTION

Line 9028: mtl_serial_numbers WHERE

9024: END IF;
9025:
9026: BEGIN
9027: SELECT group_mark_id INTO l_group_mark_id FROM
9028: mtl_serial_numbers WHERE
9029: serial_number = l_serial_number(l_serial_index).serial_number AND
9030: inventory_item_id = l_rsv_rec.inventory_item_id AND
9031: current_organization_id = l_rsv_rec.organization_id;
9032: EXCEPTION

Line 9053: UPDATE mtl_serial_numbers SET reservation_id =

9049: RAISE fnd_api.g_exc_error;
9050: END IF;
9051:
9052: BEGIN
9053: UPDATE mtl_serial_numbers SET reservation_id =
9054: l_reservation_id, group_mark_id =
9055: l_reservation_id WHERE
9056: serial_number = l_serial_number(l_serial_index).serial_number AND
9057: inventory_item_id = l_rsv_rec.inventory_item_id AND

Line 10457: mtl_serial_numbers WHERE reservation_id =

10453: END IF;
10454: BEGIN
10455: SELECT inventory_item_id, serial_number bulk collect INTO
10456: l_serial_number_table FROM
10457: mtl_serial_numbers WHERE reservation_id =
10458: l_orig_rsv_tbl(1).reservation_id AND current_organization_id =
10459: l_orig_rsv_tbl(1).organization_id AND inventory_item_id = l_orig_rsv_tbl(1).inventory_item_id;
10460: EXCEPTION
10461: WHEN no_data_found THEN

Line 10513: UPDATE mtl_serial_numbers SET reservation_id = NULL,

10509:
10510: FOR i IN 1..l_serials_tobe_unreserved
10511: LOOP
10512: BEGIN
10513: UPDATE mtl_serial_numbers SET reservation_id = NULL,
10514: group_mark_id = NULL, line_mark_id = NULL,
10515: lot_line_mark_id = NULL WHERE
10516: serial_number = l_serial_number_table(i).serial_number AND
10517: current_organization_id = l_orig_rsv_tbl(1).organization_id AND

Line 10556: UPDATE mtl_serial_numbers SET reservation_id = l_orig_rsv_tbl(1).reservation_id,

10552: debug_print('item' ||
10553: l_orig_rsv_tbl(1).inventory_item_id);
10554: END IF;
10555: BEGIN
10556: UPDATE mtl_serial_numbers SET reservation_id = l_orig_rsv_tbl(1).reservation_id,
10557: group_mark_id = l_orig_rsv_tbl(1).reservation_id WHERE
10558: serial_number = l_serial_number_table(l_serial_index).serial_number
10559: AND current_organization_id = l_orig_rsv_tbl(1).organization_id
10560: AND inventory_item_id = l_orig_rsv_tbl(1).inventory_item_id;

Line 10595: FROM mtl_serial_numbers WHERE

10591: LOOP
10592: BEGIN
10593: SELECT reservation_id, group_mark_id INTO
10594: l_reservation_id,l_group_mark_id
10595: FROM mtl_serial_numbers WHERE
10596: serial_number = p_to_serial_number(i).serial_number AND
10597: current_organization_id = l_orig_rsv_tbl(1).organization_id AND
10598: inventory_item_id = l_orig_rsv_tbl(1).inventory_item_id;
10599: EXCEPTION

Line 10641: UPDATE mtl_serial_numbers SET reservation_id = NULL,

10637: FOR i IN
10638: p_original_serial_number.first..p_original_serial_number.last
10639: LOOP
10640: BEGIN
10641: UPDATE mtl_serial_numbers SET reservation_id = NULL,
10642: group_mark_id = NULL, line_mark_id = NULL,
10643: lot_line_mark_id = NULL WHERE
10644: serial_number = p_original_serial_number(i).serial_number AND
10645: current_organization_id = l_orig_rsv_tbl(1).organization_id AND

Line 10672: UPDATE mtl_serial_numbers SET reservation_id = l_orig_rsv_tbl(1).reservation_id,

10668: l_orig_rsv_tbl(1).organization_id);
10669: debug_print('inventory_item_id = ' || l_orig_rsv_tbl(1).inventory_item_id);
10670: END IF;
10671: BEGIN
10672: UPDATE mtl_serial_numbers SET reservation_id = l_orig_rsv_tbl(1).reservation_id,
10673: group_mark_id = l_orig_rsv_tbl(1).reservation_id WHERE
10674: serial_number = p_to_serial_number(i).serial_number AND
10675: current_organization_id = l_orig_rsv_tbl(1).organization_id AND
10676: inventory_item_id = l_orig_rsv_tbl(1).inventory_item_id;

Line 10699: mtl_serial_numbers WHERE reservation_id =

10695: debug_print('inventory_item_id = ' || l_orig_rsv_tbl(1).inventory_item_id);
10696: END IF;
10697: BEGIN
10698: SELECT COUNT(1) INTO l_total_serials_reserved FROM
10699: mtl_serial_numbers WHERE reservation_id =
10700: l_orig_rsv_tbl(1).reservation_id AND current_organization_id =
10701: l_orig_rsv_tbl(1).organization_id AND inventory_item_id = l_orig_rsv_tbl(1).inventory_item_id;
10702: EXCEPTION
10703: WHEN no_data_found THEN

Line 10725: mtl_serial_numbers WHERE reservation_id =

10721:
10722: BEGIN
10723: SELECT inventory_item_id, serial_number bulk collect INTO
10724: l_serial_number_table FROM
10725: mtl_serial_numbers WHERE reservation_id =
10726: l_orig_rsv_tbl(1).reservation_id AND current_organization_id =
10727: l_orig_rsv_tbl(1).organization_id AND inventory_item_id = l_orig_rsv_tbl(1).inventory_item_id;
10728: EXCEPTION
10729: WHEN no_data_found THEN

Line 10742: UPDATE mtl_serial_numbers SET reservation_id = NULL,

10738: IF (l_debug = 1) THEN
10739: debug_print('Serial being unreserved' || l_serial_number_table(i).serial_number);
10740: END IF;
10741: BEGIN
10742: UPDATE mtl_serial_numbers SET reservation_id = NULL,
10743: group_mark_id = NULL, line_mark_id = NULL,
10744: lot_line_mark_id = NULL WHERE
10745: serial_number = l_serial_number_table(i).serial_number AND
10746: current_organization_id = l_orig_rsv_tbl(1).organization_id AND

Line 11439: -- update the mtl_serial_numbers, null out the reservation_id

11435: END IF;
11436: -- End changes for bug 3827307
11437:
11438: /*** {{ R12 Enhanced reservations code changes ***/
11439: -- update the mtl_serial_numbers, null out the reservation_id
11440: -- and group_mark_id of the reserved serials before delete the
11441: -- reservation. There is no need to update the serial_reservation_quantity
11442: -- because the reservation record will be deleted.
11443: BEGIN

Line 11444: update mtl_serial_numbers

11440: -- and group_mark_id of the reserved serials before delete the
11441: -- reservation. There is no need to update the serial_reservation_quantity
11442: -- because the reservation record will be deleted.
11443: BEGIN
11444: update mtl_serial_numbers
11445: set reservation_id = NULL,
11446: group_mark_id = NULL,
11447: line_mark_id = NULL,
11448: lot_line_mark_id = NULL

Line 11569: -- reservation_id in mtl_serial_numbers of the serial numbers pass in the record.

11565: -- INVCONV END
11566:
11567: /*** {{ R12 Enhanced reservations code changes ***/
11568: -- if serial record is not empty, then unmark the group_mark_id and
11569: -- reservation_id in mtl_serial_numbers of the serial numbers pass in the record.
11570: -- also update the serial_reservation_quantity in the mtl_reservations.
11571: -- if serial record is empty, need to get the serials with reservation_id and
11572: -- unmark the serial until the serial_reservation_quantity = primary_reservation_quantity
11573: IF (p_original_serial_number.COUNT > 0) THEN

Line 11585: UPDATE mtl_serial_numbers

11581: p_original_serial_number(i).serial_number);
11582: debug_print('item ' || l_tmp_rsv_tbl(1).inventory_item_id);
11583: END IF;
11584: BEGIN
11585: UPDATE mtl_serial_numbers
11586: SET reservation_id = NULL,
11587: group_mark_id = NULL, line_mark_id = NULL,
11588: lot_line_mark_id = NULL
11589: WHERE serial_number = p_original_serial_number(i).serial_number

Line 11637: FROM mtl_serial_numbers

11633:
11634: BEGIN
11635: SELECT inventory_item_id,serial_number BULK COLLECT
11636: INTO l_serial_number_table
11637: FROM mtl_serial_numbers
11638: WHERE reservation_id = l_reservation_id;
11639: EXCEPTION
11640: WHEN no_data_found THEN
11641: IF (l_debug = 1) THEN

Line 11672: UPDATE mtl_serial_numbers

11668: debug_print('inside relieve. serial ' ||
11669: l_serial_number_table(i).serial_number);
11670: debug_print('inside relieve. item ' || l_serial_number_table(i).serial_number);
11671: END IF;
11672: UPDATE mtl_serial_numbers
11673: SET reservation_id = NULL,
11674: group_mark_id = NULL, line_mark_id = NULL,
11675: lot_line_mark_id = NULL
11676: WHERE serial_number = l_serial_number_table(i).serial_number

Line 11717: FROM mtl_serial_numbers

11713:
11714: BEGIN
11715: SELECT inventory_item_id, serial_number BULK COLLECT
11716: INTO l_serial_number_table
11717: FROM mtl_serial_numbers
11718: WHERE reservation_id = l_reservation_id;
11719: EXCEPTION
11720: WHEN no_data_found THEN
11721: IF (l_debug = 1) THEN

Line 11740: UPDATE mtl_serial_numbers

11736: END IF;
11737:
11738: FOR i in 1..l_count_to_unrsv_serials LOOP
11739: BEGIN
11740: UPDATE mtl_serial_numbers
11741: SET reservation_id = NULL,
11742: group_mark_id = NULL, line_mark_id = NULL,
11743: lot_line_mark_id = NULL
11744: WHERE serial_number = l_serial_number_table(i).serial_number

Line 12114: -- update the mtl_serial_numbers, null out the reservation_id

12110: RAISE fnd_api.g_exc_unexpected_error;
12111: END IF;
12112:
12113: /*** {{ R12 Enhanced reservations code changes ***/
12114: -- update the mtl_serial_numbers, null out the reservation_id
12115: -- and group_mark_id of the reserved serials before delete the
12116: -- reservation. There is no need to update the serial_reservation_quantity
12117: -- because the reservation record will be deleted.
12118: BEGIN

Line 12119: update mtl_serial_numbers

12115: -- and group_mark_id of the reserved serials before delete the
12116: -- reservation. There is no need to update the serial_reservation_quantity
12117: -- because the reservation record will be deleted.
12118: BEGIN
12119: update mtl_serial_numbers
12120: set reservation_id = NULL,
12121: group_mark_id = NULL, line_mark_id = NULL,
12122: lot_line_mark_id = NULL
12123: where reservation_id = l_reservation_id;

Line 14186: mtl_serial_numbers WHERE reservation_id =

14182:
14183: BEGIN
14184: SELECT inventory_item_id, serial_number bulk collect INTO
14185: l_serial_number_table FROM
14186: mtl_serial_numbers WHERE reservation_id =
14187: l_orig_rsv_tbl(1).reservation_id AND current_organization_id =
14188: l_orig_rsv_tbl(1).organization_id AND inventory_item_id = l_orig_rsv_tbl(1).inventory_item_id;
14189: EXCEPTION
14190: WHEN no_data_found THEN

Line 14323: UPDATE mtl_serial_numbers SET reservation_id = l_to_reservation_id,

14319: -- reservation id are populated.
14320: FOR l_serial_index IN l_serial_number_table.first..l_serial_number_table.last
14321: LOOP
14322: BEGIN
14323: UPDATE mtl_serial_numbers SET reservation_id = l_to_reservation_id,
14324: group_mark_id = l_to_reservation_id WHERE
14325: serial_number = l_serial_number_table(l_serial_index).serial_number AND
14326: inventory_item_id = l_orig_rsv_tbl(1).inventory_item_id AND
14327: current_organization_id = l_orig_rsv_tbl(1).organization_id;

Line 14382: UPDATE mtl_serial_numbers SET reservation_id = l_to_reservation_id,

14378:
14379: FOR i IN 1..l_serials_tobe_unreserved
14380: LOOP
14381: BEGIN
14382: UPDATE mtl_serial_numbers SET reservation_id = l_to_reservation_id,
14383: group_mark_id = l_to_reservation_id WHERE
14384: serial_number = l_serial_number_table(i).serial_number AND
14385: inventory_item_id = l_orig_rsv_tbl(1).inventory_item_id AND
14386: current_organization_id = l_orig_rsv_tbl(1).organization_id;

Line 14449: mtl_serial_numbers WHERE reservation_id =

14445: -- check to see if we are transferring more than the
14446: -- reserved qty
14447: BEGIN
14448: SELECT COUNT(1) INTO l_total_to_serials_reserved FROM
14449: mtl_serial_numbers WHERE reservation_id =
14450: l_to_reservation_id AND current_organization_id =
14451: l_orig_rsv_tbl(1).organization_id AND inventory_item_id = l_orig_rsv_tbl(1).inventory_item_id;
14452: EXCEPTION
14453: WHEN no_data_found THEN

Line 14496: SELECT reservation_id INTO l_from_reservation_id FROM mtl_serial_numbers WHERE

14492: -- The serial has to be reserved to the from record
14493: FOR i IN p_original_serial_number.first..p_original_serial_number.last
14494: LOOP
14495: BEGIN
14496: SELECT reservation_id INTO l_from_reservation_id FROM mtl_serial_numbers WHERE
14497: serial_number = p_original_serial_number(i).serial_number AND
14498: current_organization_id = l_orig_rsv_tbl(1).organization_id AND
14499: inventory_item_id = l_orig_rsv_tbl(1).inventory_item_id;
14500: EXCEPTION

Line 14519: UPDATE mtl_serial_numbers SET reservation_id = NULL,

14515:
14516: IF (l_total_serials_reserved > 0) THEN
14517: -- unreserve the passed serials.
14518: BEGIN
14519: UPDATE mtl_serial_numbers SET reservation_id = NULL,
14520: group_mark_id = NULL, line_mark_id = NULL,
14521: lot_line_mark_id = NULL WHERE
14522: serial_number = p_original_serial_number(i).serial_number AND
14523: current_organization_id = l_orig_rsv_tbl(1).organization_id AND

Line 14547: mtl_serial_numbers WHERE reservation_id =

14543:
14544: BEGIN
14545: SELECT inventory_item_id, serial_number bulk collect INTO
14546: l_validate_serial_number_table FROM
14547: mtl_serial_numbers WHERE reservation_id =
14548: l_orig_rsv_tbl(1).reservation_id AND current_organization_id =
14549: l_orig_rsv_tbl(1).organization_id AND inventory_item_id = l_orig_rsv_tbl(1).inventory_item_id;
14550: EXCEPTION
14551: WHEN no_data_found THEN

Line 14592: UPDATE mtl_serial_numbers SET reservation_id = l_to_reservation_id,

14588: END IF;
14589: END IF;
14590:
14591: BEGIN
14592: UPDATE mtl_serial_numbers SET reservation_id = l_to_reservation_id,
14593: group_mark_id = l_to_reservation_id WHERE
14594: reservation_id = l_orig_rsv_tbl(1).reservation_id AND current_organization_id =
14595: l_orig_rsv_tbl(1).organization_id AND inventory_item_id = l_orig_rsv_tbl(1).inventory_item_id;
14596:

Line 14610: mtl_serial_numbers WHERE reservation_id =

14606:
14607: -- check to see if we have reserved more than the to_record
14608: BEGIN
14609: SELECT COUNT(1) INTO l_total_to_serials_reserved FROM
14610: mtl_serial_numbers WHERE reservation_id =
14611: l_to_reservation_id AND current_organization_id =
14612: l_orig_rsv_tbl(1).organization_id AND inventory_item_id = l_orig_rsv_tbl(1).inventory_item_id;
14613: EXCEPTION
14614: WHEN no_data_found THEN

Line 14657: mtl_serial_numbers WHERE reservation_id =

14653: END IF;
14654: BEGIN
14655: SELECT inventory_item_id, serial_number bulk collect INTO
14656: l_validate_serial_number_table FROM
14657: mtl_serial_numbers WHERE reservation_id =
14658: l_orig_rsv_tbl(1).reservation_id AND current_organization_id =
14659: l_orig_rsv_tbl(1).organization_id AND inventory_item_id = l_orig_rsv_tbl(1).inventory_item_id;
14660: EXCEPTION
14661: WHEN no_data_found THEN

Line 14709: UPDATE mtl_serial_numbers SET reservation_id = l_to_reservation_id,

14705:
14706: FOR i IN 1..l_serials_tobe_unreserved
14707: LOOP
14708: BEGIN
14709: UPDATE mtl_serial_numbers SET reservation_id = l_to_reservation_id,
14710: group_mark_id = l_to_reservation_id WHERE
14711: serial_number = l_validate_serial_number_table(i).serial_number AND
14712: inventory_item_id = l_orig_rsv_tbl(1).inventory_item_id AND
14713: current_organization_id = l_orig_rsv_tbl(1).organization_id;

Line 14732: mtl_serial_numbers WHERE reservation_id =

14728: END LOOP;
14729:
14730: BEGIN
14731: SELECT COUNT(1) INTO l_total_to_serials_reserved FROM
14732: mtl_serial_numbers WHERE reservation_id =
14733: l_to_reservation_id AND current_organization_id =
14734: l_orig_rsv_tbl(1).organization_id AND inventory_item_id = l_orig_rsv_tbl(1).inventory_item_id;
14735: EXCEPTION
14736: WHEN no_data_found THEN

Line 14808: mtl_serial_numbers WHERE reservation_id =

14804: END IF;
14805: BEGIN
14806: SELECT inventory_item_id, serial_number bulk collect INTO
14807: l_validate_serial_number_table FROM
14808: mtl_serial_numbers WHERE reservation_id =
14809: l_orig_rsv_tbl(1).reservation_id AND current_organization_id =
14810: l_orig_rsv_tbl(1).organization_id AND inventory_item_id = l_orig_rsv_tbl(1).inventory_item_id;
14811: EXCEPTION
14812: WHEN no_data_found THEN

Line 14907: l_from_reservation_id, l_group_mark_id FROM mtl_serial_numbers WHERE

14903: debug_print('Processing serial number' || p_to_serial_number(i).serial_number);
14904: END IF;
14905:
14906: SELECT reservation_id, group_mark_id INTO
14907: l_from_reservation_id, l_group_mark_id FROM mtl_serial_numbers WHERE
14908: serial_number = p_to_serial_number(i).serial_number AND
14909: current_organization_id = l_orig_rsv_tbl(1).organization_id AND
14910: inventory_item_id = l_orig_rsv_tbl(1).inventory_item_id;
14911: EXCEPTION

Line 14943: UPDATE mtl_serial_numbers SET reservation_id = l_to_reservation_id,

14939: RAISE fnd_api.g_exc_error;
14940: END IF;
14941:
14942: BEGIN
14943: UPDATE mtl_serial_numbers SET reservation_id = l_to_reservation_id,
14944: group_mark_id = l_to_reservation_id WHERE
14945: serial_number = p_to_serial_number(i).serial_number AND
14946: current_organization_id = l_orig_rsv_tbl(1).organization_id AND
14947: inventory_item_id = l_orig_rsv_tbl(1).inventory_item_id;

Line 15001: UPDATE mtl_serial_numbers SET reservation_id = l_to_reservation_id,

14997: -- reservation id are populated.
14998: FOR l_serial_index IN l_serial_number_table.first..l_serial_number_table.last
14999: LOOP
15000: BEGIN
15001: UPDATE mtl_serial_numbers SET reservation_id = l_to_reservation_id,
15002: group_mark_id = l_to_reservation_id WHERE
15003: serial_number = l_serial_number_table(l_serial_index).serial_number AND
15004: inventory_item_id = l_orig_rsv_tbl(1).inventory_item_id AND
15005: current_organization_id = l_orig_rsv_tbl(1).organization_id;

Line 15024: mtl_serial_numbers WHERE reservation_id =

15020: END LOOP;
15021:
15022: BEGIN
15023: SELECT COUNT(1) INTO l_total_to_serials_reserved FROM
15024: mtl_serial_numbers WHERE reservation_id =
15025: l_to_reservation_id AND current_organization_id =
15026: l_orig_rsv_tbl(1).organization_id AND inventory_item_id = l_orig_rsv_tbl(1).inventory_item_id;
15027: EXCEPTION
15028: WHEN no_data_found THEN

Line 15113: mtl_serial_numbers WHERE reservation_id =

15109: -- the serial reservation quantity. check to see if the
15110: -- count exceeds
15111: BEGIN
15112: SELECT COUNT(1) INTO l_total_to_serials_reserved FROM
15113: mtl_serial_numbers WHERE reservation_id =
15114: l_orig_rsv_tbl(1).reservation_id AND current_organization_id = l_orig_rsv_tbl(1).organization_id AND inventory_item_id = l_orig_rsv_tbl(1).inventory_item_id;
15115: EXCEPTION
15116: WHEN no_data_found THEN
15117: IF l_debug=1 THEN

Line 15170: mtl_serial_numbers WHERE reservation_id =

15166: IF (l_total_serials_reserved > 0) THEN
15167: BEGIN
15168: SELECT inventory_item_id, serial_number bulk collect INTO
15169: l_validate_serial_number_table FROM
15170: mtl_serial_numbers WHERE reservation_id =
15171: l_orig_rsv_tbl(1).reservation_id AND current_organization_id =
15172: l_orig_rsv_tbl(1).organization_id AND inventory_item_id = l_orig_rsv_tbl(1).inventory_item_id;
15173: EXCEPTION
15174: WHEN no_data_found THEN

Line 15222: UPDATE mtl_serial_numbers SET

15218:
15219: FOR i IN 1..l_serials_tobe_unreserved
15220: LOOP
15221: BEGIN
15222: UPDATE mtl_serial_numbers SET
15223: reservation_id = l_to_reservation_id,
15224: group_mark_id = l_to_reservation_id WHERE
15225: serial_number = l_validate_serial_number_table(i).serial_number AND
15226: inventory_item_id = l_orig_rsv_tbl(1).inventory_item_id AND

Line 15248: mtl_serial_numbers WHERE reservation_id =

15244: END IF;
15245:
15246: BEGIN
15247: SELECT COUNT(1) INTO l_total_to_serials_reserved FROM
15248: mtl_serial_numbers WHERE reservation_id =
15249: l_to_reservation_id AND current_organization_id =
15250: l_orig_rsv_tbl(1).organization_id AND inventory_item_id = l_orig_rsv_tbl(1).inventory_item_id;
15251: EXCEPTION
15252: WHEN no_data_found THEN

Line 15281: mtl_serial_numbers WHERE reservation_id =

15277: END;
15278:
15279: BEGIN
15280: SELECT COUNT(1) INTO l_total_from_serials_reserved FROM
15281: mtl_serial_numbers WHERE reservation_id =
15282: l_orig_rsv_tbl(1).reservation_id AND
15283: current_organization_id = l_orig_rsv_tbl(1).organization_id AND inventory_item_id = l_orig_rsv_tbl(1).inventory_item_id;
15284: EXCEPTION
15285: WHEN no_data_found THEN

Line 15327: SELECT reservation_id INTO l_from_reservation_id FROM mtl_serial_numbers WHERE

15323: -- The serial has to be reserved to the from record
15324: FOR i IN p_original_serial_number.first..p_original_serial_number.last
15325: LOOP
15326: BEGIN
15327: SELECT reservation_id INTO l_from_reservation_id FROM mtl_serial_numbers WHERE
15328: serial_number = p_original_serial_number(i).serial_number AND
15329: current_organization_id = l_orig_rsv_tbl(1).organization_id AND
15330: inventory_item_id = l_orig_rsv_tbl(1).inventory_item_id;
15331: EXCEPTION

Line 15349: UPDATE mtl_serial_numbers SET reservation_id = NULL,

15345: END IF;
15346:
15347: -- unreserve the passed serials.
15348: BEGIN
15349: UPDATE mtl_serial_numbers SET reservation_id = NULL,
15350: group_mark_id = NULL, line_mark_id = NULL,
15351: lot_line_mark_id = NULL WHERE
15352: serial_number = p_original_serial_number(i).serial_number AND
15353: current_organization_id = l_orig_rsv_tbl(1).organization_id AND

Line 15373: l_from_reservation_id, l_group_mark_id FROM mtl_serial_numbers WHERE

15369: FOR i IN p_to_serial_number.first..p_to_serial_number.last
15370: LOOP
15371: BEGIN
15372: SELECT reservation_id, group_mark_id INTO
15373: l_from_reservation_id, l_group_mark_id FROM mtl_serial_numbers WHERE
15374: serial_number = p_to_serial_number(i).serial_number AND
15375: current_organization_id = l_orig_rsv_tbl(1).organization_id AND
15376: inventory_item_id = l_orig_rsv_tbl(1).inventory_item_id;
15377: EXCEPTION

Line 15404: UPDATE mtl_serial_numbers SET reservation_id = l_to_reservation_id,

15400: RAISE fnd_api.g_exc_error;
15401: END IF;
15402:
15403: BEGIN
15404: UPDATE mtl_serial_numbers SET reservation_id = l_to_reservation_id,
15405: group_mark_id = l_to_reservation_id WHERE
15406: serial_number = p_to_serial_number(i).serial_number AND
15407: current_organization_id = l_orig_rsv_tbl(1).organization_id AND
15408: inventory_item_id = l_orig_rsv_tbl(1).inventory_item_id;

Line 15430: mtl_serial_numbers WHERE reservation_id =

15426: IF (l_total_serials_reserved > 0) THEN
15427: BEGIN
15428: SELECT inventory_item_id, serial_number bulk collect INTO
15429: l_validate_serial_number_table FROM
15430: mtl_serial_numbers WHERE reservation_id =
15431: l_orig_rsv_tbl(1).reservation_id AND current_organization_id =
15432: l_orig_rsv_tbl(1).organization_id AND inventory_item_id = l_orig_rsv_tbl(1).inventory_item_id;
15433: EXCEPTION
15434: WHEN no_data_found THEN

Line 15471: UPDATE mtl_serial_numbers SET reservation_id = l_to_reservation_id,

15467: RAISE fnd_api.g_exc_unexpected_error;
15468: END IF;
15469:
15470: BEGIN
15471: UPDATE mtl_serial_numbers SET reservation_id = l_to_reservation_id,
15472: group_mark_id = l_to_reservation_id WHERE
15473: reservation_id = l_orig_rsv_tbl(1).reservation_id AND current_organization_id =
15474: l_orig_rsv_tbl(1).organization_id AND inventory_item_id = l_orig_rsv_tbl(1).inventory_item_id;
15475:

Line 15490: mtl_serial_numbers WHERE reservation_id =

15486: END IF;
15487:
15488: BEGIN
15489: SELECT COUNT(1) INTO l_total_to_serials_reserved FROM
15490: mtl_serial_numbers WHERE reservation_id =
15491: l_to_reservation_id AND current_organization_id =
15492: l_orig_rsv_tbl(1).organization_id AND inventory_item_id = l_orig_rsv_tbl(1).inventory_item_id;
15493: EXCEPTION
15494: WHEN no_data_found THEN

Line 15535: mtl_serial_numbers WHERE reservation_id =

15531: IF (l_total_serials_reserved > 0) THEN
15532: BEGIN
15533: SELECT inventory_item_id, serial_number bulk collect INTO
15534: l_validate_serial_number_table FROM
15535: mtl_serial_numbers WHERE reservation_id =
15536: l_orig_rsv_tbl(1).reservation_id AND current_organization_id =
15537: l_orig_rsv_tbl(1).organization_id AND inventory_item_id = l_orig_rsv_tbl(1).inventory_item_id;
15538: EXCEPTION
15539: WHEN no_data_found THEN

Line 15579: mtl_serial_numbers WHERE reservation_id =

15575: END IF;
15576:
15577: BEGIN
15578: SELECT COUNT(1) INTO l_total_to_serials_reserved FROM
15579: mtl_serial_numbers WHERE reservation_id =
15580: l_orig_rsv_tbl(1).reservation_id AND current_organization_id =
15581: l_orig_rsv_tbl(1).organization_id AND inventory_item_id = l_orig_rsv_tbl(1).inventory_item_id;
15582: EXCEPTION
15583: WHEN no_data_found THEN

Line 15622: mtl_serial_numbers WHERE reservation_id =

15618: IF (l_total_serials_reserved > 0) THEN
15619: BEGIN
15620: SELECT inventory_item_id, serial_number bulk collect INTO
15621: l_validate_serial_number_table FROM
15622: mtl_serial_numbers WHERE reservation_id =
15623: l_orig_rsv_tbl(1).reservation_id AND current_organization_id =
15624: l_orig_rsv_tbl(1).organization_id AND inventory_item_id = l_orig_rsv_tbl(1).inventory_item_id;
15625: EXCEPTION
15626: WHEN no_data_found THEN

Line 15674: UPDATE mtl_serial_numbers SET reservation_id = l_to_reservation_id,

15670:
15671: FOR i IN 1..l_serials_tobe_unreserved
15672: LOOP
15673: BEGIN
15674: UPDATE mtl_serial_numbers SET reservation_id = l_to_reservation_id,
15675: group_mark_id = l_to_reservation_id WHERE
15676: serial_number = l_validate_serial_number_table(i).serial_number AND
15677: inventory_item_id = l_orig_rsv_tbl(1).inventory_item_id AND
15678: current_organization_id = l_orig_rsv_tbl(1).organization_id;

Line 15700: mtl_serial_numbers WHERE reservation_id =

15696: END IF;
15697:
15698: BEGIN
15699: SELECT COUNT(1) INTO l_total_to_serials_reserved FROM
15700: mtl_serial_numbers WHERE reservation_id =
15701: l_to_reservation_id AND current_organization_id =
15702: l_orig_rsv_tbl(1).organization_id AND inventory_item_id = l_orig_rsv_tbl(1).inventory_item_id;
15703: EXCEPTION
15704: WHEN no_data_found THEN

Line 15732: mtl_serial_numbers WHERE reservation_id =

15728: END;
15729:
15730: BEGIN
15731: SELECT COUNT(1) INTO l_total_from_serials_reserved FROM
15732: mtl_serial_numbers WHERE reservation_id =
15733: l_orig_rsv_tbl(1).reservation_id AND current_organization_id =
15734: l_orig_rsv_tbl(1).organization_id AND inventory_item_id = l_orig_rsv_tbl(1).inventory_item_id;
15735: EXCEPTION
15736: WHEN no_data_found THEN

Line 17195: From Mtl_Serial_Numbers

17191: ,v_Inventory_Item_Id Number
17192: ,v_Organization_Id Number ) IS
17193:
17194: Select Reservation_ID
17195: From Mtl_Serial_Numbers
17196: Where Inventory_Item_Id = v_Inventory_Item_Id
17197: and current_organization_id = v_Organization_id
17198: and Serial_Number = v_Serial_Number;
17199: BEGIN

Line 17214: -- Check if reservation id parameter has any value if not then get value from mtl_serial_numbers table.

17210: END IF;
17211:
17212: l_debug := g_debug;
17213:
17214: -- Check if reservation id parameter has any value if not then get value from mtl_serial_numbers table.
17215: If p_original_Reservation_Id IS Null THEN
17216: IF (l_debug = 1) THEN
17217: debug_print('reservation_id is not passed');
17218: END IF;

Line 17354: mtl_serial_numbers msn

17350: SELECT msn.reservation_id,
17351: msn.serial_number,
17352: msn.inventory_item_id
17353: FROM mtl_reservations mr,
17354: mtl_serial_numbers msn
17355: WHERE mr.organization_id = p_organization_id
17356: AND mr.inventory_item_id = p_inventory_item_id
17357: AND mr.reservation_id = msn.reservation_id
17358: AND mr.lpn_id = null

Line 17372: mtl_serial_numbers msn

17368: SELECT msn.reservation_id,
17369: msn.serial_number,
17370: msn.inventory_item_id
17371: FROM mtl_reservations mr,
17372: mtl_serial_numbers msn
17373: WHERE mr.organization_id = p_organization_id
17374: AND mr.reservation_id = msn.reservation_id
17375: AND mr.lpn_id = null
17376: AND msn.lpn_id IN (SELECT lpn_id

Line 17389: mtl_serial_numbers msn

17385: SELECT msn.reservation_id,
17386: msn.serial_number,
17387: msn.inventory_item_id
17388: FROM mtl_reservations mr,
17389: mtl_serial_numbers msn
17390: WHERE mr.organization_id = p_organization_id
17391: AND mr.inventory_item_id = p_inventory_item_id
17392: AND mr.reservation_id = msn.reservation_id
17393: AND mr.lpn_id = null

Line 17405: mtl_serial_numbers msn

17401: SELECT msn.reservation_id,
17402: msn.serial_number,
17403: msn.inventory_item_id
17404: FROM mtl_reservations mr,
17405: mtl_serial_numbers msn
17406: WHERE mr.organization_id = p_organization_id
17407: AND mr.reservation_id = msn.reservation_id
17408: AND mr.lpn_id = null
17409: AND msn.lpn_id = p_lpn_id