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_RESERVATIONS

Line 2349: update mtl_reservations

2345: debug_print('reservation_id = ' || p_reservation_id);
2346: debug_print('update_serial_qty = ' || p_update_serial_qty);
2347: END IF;
2348:
2349: update mtl_reservations
2350: set serial_reservation_quantity = serial_reservation_quantity + p_update_serial_qty
2351: where reservation_id = p_reservation_id;
2352: l_update_count := SQL%ROWCOUNT;
2353:

Line 2540: FROM mtl_reservations

2536: , orig_demand_source_header_id
2537: , orig_demand_source_line_id
2538: , orig_demand_source_line_detail
2539: , serial_number
2540: FROM mtl_reservations
2541: WHERE reservation_id = p_reservation_id;
2542: BEGIN
2543: IF (g_debug is NULL) THEN
2544: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 3575: FROM mtl_reservations

3571: , orig_demand_source_line_id
3572: , orig_demand_source_line_detail
3573: , serial_number
3574: /***** End R12 ***/
3575: FROM mtl_reservations
3576: WHERE reservation_id = p_query_input.reservation_id
3577: FOR UPDATE --NOWAIT
3578: ORDER BY NVL(revision, ' '), NVL(lot_number, ' '), NVL(subinventory_code, ' '), NVL(locator_id, 0);
3579:

Line 3657: FROM mtl_reservations

3653: , orig_demand_source_line_id
3654: , orig_demand_source_line_detail
3655: , serial_number
3656: /***** End R12 ***/
3657: FROM mtl_reservations
3658: WHERE reservation_id = p_query_input.reservation_id
3659: ORDER BY NVL(revision, ' '), NVL(lot_number, ' '), NVL(subinventory_code, ' '), NVL(locator_id, 0);
3660:
3661: -- INVCONV - Incorporate secondary quantities

Line 3739: FROM mtl_reservations

3735: , orig_demand_source_line_id
3736: , orig_demand_source_line_detail
3737: , serial_number
3738: /***** End R12 ***/
3739: FROM mtl_reservations
3740: WHERE demand_source_line_id = p_query_input.demand_source_line_id
3741: AND (p_query_input.lpn_id = l_miss_num
3742: OR p_query_input.lpn_id IS NULL
3743: AND lpn_id IS NULL

Line 4083: FROM mtl_reservations

4079: , orig_demand_source_line_id
4080: , orig_demand_source_line_detail
4081: , serial_number
4082: /***** End R12 ***/
4083: FROM mtl_reservations
4084: WHERE demand_source_line_id = p_query_input.demand_source_line_id
4085: AND (p_query_input.requirement_date = l_miss_date
4086: OR p_query_input.requirement_date IS NULL
4087: AND requirement_date IS NULL

Line 4557: FROM mtl_reservations

4553: , orig_demand_source_line_id
4554: , orig_demand_source_line_detail
4555: , serial_number
4556: /***** End R12 ***/
4557: FROM mtl_reservations
4558: WHERE
4559: :reservation_id = reservation_id '
4560: || l_lock_stmt
4561: || l_sort_stmt USING p_query_input.reservation_id;

Line 4664: FROM mtl_reservations

4660: , orig_demand_source_line_id
4661: , orig_demand_source_line_detail
4662: , serial_number
4663: /***** End R12 ***/
4664: FROM mtl_reservations
4665: WHERE
4666: demand_source_line_id = :demand_source_line_id
4667: AND
4668: (:requirement_date = :l_miss_date

Line 5302: FROM mtl_reservations

5298: , orig_demand_source_line_id
5299: , orig_demand_source_line_detail
5300: , serial_number
5301: /***** End R12 ***/
5302: FROM mtl_reservations
5303: WHERE
5304: inventory_item_id = :inventory_item_id
5305: and organization_id = :organization_id
5306: AND

Line 5936: FROM mtl_reservations

5932: , orig_demand_source_line_id
5933: , orig_demand_source_line_detail
5934: , serial_number
5935: /***** End R12 ***/
5936: FROM mtl_reservations
5937: WHERE
5938: supply_source_header_id = :supply_source_header_id
5939: and supply_source_type_id = :supply_source_type_id
5940: AND

Line 6780: FROM mtl_reservations

6776: , orig_demand_source_line_id
6777: , orig_demand_source_line_detail
6778: , serial_number
6779: /***** End R12 ***/
6780: FROM mtl_reservations
6781: WHERE
6782: (:requirement_date = :l_miss_date
6783: OR :requirement_date IS NULL
6784: AND requirement_date IS NULL

Line 8886: mtl_reservations_pkg.insert_row

8882: debug_print(' serial reservation qty = ' || l_rsv_rec.serial_reservation_quantity);
8883: END IF;
8884:
8885: -- INVCONV - Upgrade call to incorporate secondaries
8886: mtl_reservations_pkg.insert_row
8887: (
8888: x_rowid => l_rowid
8889: , x_reservation_id => l_reservation_id
8890: , x_requirement_date => l_rsv_rec.requirement_date

Line 8982: -- for data sync b/w mtl_demand and mtl_reservations

8978: END IF;
8979: IF (l_debug = 1) THEN
8980: debug_print('before sync ' || l_return_status);
8981: END IF;
8982: -- for data sync b/w mtl_demand and mtl_reservations
8983: inv_rsv_synch.for_insert(p_reservation_id => l_reservation_id, x_return_status => l_return_status, x_msg_count => x_msg_count, x_msg_data => x_msg_data);
8984:
8985: IF (l_debug = 1) THEN
8986: debug_print('After sync ' || l_return_status);

Line 10783: debug_print('Calling mtl_reservations_pkg.update_row');

10779: l_program_id := fnd_global.conc_program_id;
10780: --
10781: -- update the table
10782: IF (l_debug = 1) THEN
10783: debug_print('Calling mtl_reservations_pkg.update_row');
10784: END IF;
10785:
10786: -- Bug 3461990: Reservations API should not update reservations with more
10787: -- than 5 decimal places, since the transaction quantity is being

Line 10817: mtl_reservations_pkg.update_row

10813: debug_print(' After rounding sec detailed quantity' || l_to_rsv_rec.secondary_detailed_quantity); --INVCONV
10814: END IF;
10815:
10816: -- INVCONV - Upgrade to incorporate secondaries
10817: mtl_reservations_pkg.update_row
10818: (
10819: x_reservation_id => l_orig_rsv_tbl(1).reservation_id
10820: , x_requirement_date => l_to_rsv_rec.requirement_date
10821: , x_organization_id => l_to_rsv_rec.organization_id

Line 10896: -- for data sync b/w mtl_demand and mtl_reservations

10892: , x_task_id => l_to_rsv_rec.task_id
10893: /*** End R12 ***/
10894:
10895: );
10896: -- for data sync b/w mtl_demand and mtl_reservations
10897: IF (l_debug = 1) THEN
10898: debug_print('Calling inv_rsv_synch.for_update');
10899: END IF;
10900: inv_rsv_synch.for_update(p_reservation_id => l_orig_rsv_tbl(1).reservation_id, x_return_status => l_return_status, x_msg_count => x_msg_count, x_msg_data => x_msg_data);

Line 11459: debug_print('calling mtl_reservations_pkg.delete_row');

11455: END;
11456: /*** End R12 }} ***/
11457:
11458: IF (l_debug = 1) THEN
11459: debug_print('calling mtl_reservations_pkg.delete_row');
11460: END IF;
11461: mtl_reservations_pkg.delete_row(x_reservation_id => l_reservation_id);
11462: NULL;
11463:

Line 11461: mtl_reservations_pkg.delete_row(x_reservation_id => l_reservation_id);

11457:
11458: IF (l_debug = 1) THEN
11459: debug_print('calling mtl_reservations_pkg.delete_row');
11460: END IF;
11461: mtl_reservations_pkg.delete_row(x_reservation_id => l_reservation_id);
11462: NULL;
11463:
11464: ELSE
11465:

Line 11570: -- also update the serial_reservation_quantity in the mtl_reservations.

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
11574: l_count := 0;

Line 11766: UPDATE mtl_reservations

11762: debug_print('update reservation');
11763: END IF;
11764:
11765: -- INVCONV - Incorporate secondaries
11766: UPDATE mtl_reservations
11767: SET primary_reservation_quantity = l_tmp_rsv_tbl(1).primary_reservation_quantity
11768: , secondary_reservation_quantity = l_tmp_rsv_tbl(1).secondary_reservation_quantity
11769: , reservation_quantity = l_tmp_rsv_tbl(1).reservation_quantity
11770: , last_update_date = l_date

Line 12101: -- for data sync b/w mtl_demand and mtl_reservations

12097: debug_print('After calling inventory_unreservation_check...' || l_return_status);
12098: END IF;
12099:
12100: --
12101: -- for data sync b/w mtl_demand and mtl_reservations
12102: inv_rsv_synch.for_delete(p_reservation_id => l_reservation_id, x_return_status => l_return_status, x_msg_count => x_msg_count, x_msg_data => x_msg_data);
12103:
12104: IF l_return_status = fnd_api.g_ret_sts_error THEN
12105: RAISE fnd_api.g_exc_error;

Line 12135: mtl_reservations_pkg.delete_row(x_reservation_id => l_reservation_id);

12131:
12132: --
12133: --
12134: -- delete the reservation from the db table
12135: mtl_reservations_pkg.delete_row(x_reservation_id => l_reservation_id);
12136:
12137: -- Post Delete CTO Validation
12138: IF l_tmp_rsv_tbl(1).demand_source_type_id IN (inv_reservation_global.g_source_type_oe, inv_reservation_global.g_source_type_internal_ord, inv_reservation_global.g_source_type_rma) THEN
12139: --

Line 13388: UPDATE mtl_reservations

13384: debug_print(' After rounding detailed quantity' || l_detailed_quantity);
13385: END IF;
13386:
13387: -- INVCONV - Incorporate secondary_reservation_quantity
13388: UPDATE mtl_reservations
13389: SET primary_reservation_quantity = l_new_orig_prim_qty
13390: , secondary_reservation_quantity = l_orig_second_rsv_qty
13391: , reservation_quantity = l_new_orig_rsv_qty
13392: , detailed_quantity = l_detailed_quantity

Line 13402: -- for data sync b/w mtl_demand and mtl_reservations

13398: , program_id = l_program_id
13399: , program_update_date = l_date
13400: WHERE reservation_id = l_orig_rsv_tbl(1).reservation_id;
13401:
13402: -- for data sync b/w mtl_demand and mtl_reservations
13403: inv_rsv_synch.for_update(p_reservation_id => l_orig_rsv_tbl(1).reservation_id, x_return_status => l_return_status, x_msg_count => x_msg_count, x_msg_data => x_msg_data);
13404:
13405: IF l_return_status = fnd_api.g_ret_sts_error THEN
13406: RAISE fnd_api.g_exc_error;

Line 13470: -- for data sync b/w mtl_demand and mtl_reservations

13466: END IF;
13467: --
13468: END IF;
13469:
13470: -- for data sync b/w mtl_demand and mtl_reservations
13471: inv_rsv_synch.for_delete(p_reservation_id => l_orig_rsv_tbl(1).reservation_id, x_return_status => l_return_status, x_msg_count => x_msg_count, x_msg_data => x_msg_data);
13472:
13473: IF l_return_status = fnd_api.g_ret_sts_error THEN
13474: RAISE fnd_api.g_exc_error;

Line 13483: mtl_reservations_pkg.delete_row

13479: RAISE fnd_api.g_exc_unexpected_error;
13480: END IF;
13481:
13482: -- 2884492
13483: mtl_reservations_pkg.delete_row
13484: (x_reservation_id => l_orig_rsv_tbl(1).reservation_id
13485: ,x_to_reservation_id => l_to_rsv_tbl(1).reservation_id);
13486: /** commented out by request of CTO. The workflow was not processing
13487: * correctly.

Line 13625: mtl_reservations_pkg.update_row

13621: debug_print(' After rounding detailed quantity' ||l_to_rsv_rec.detailed_quantity );
13622: END IF;
13623:
13624: -- INVCONV - Incorporate secondaries in update
13625: mtl_reservations_pkg.update_row
13626: (
13627: x_reservation_id => l_orig_rsv_tbl(1).reservation_id
13628: , x_requirement_date => l_to_rsv_rec.requirement_date
13629: , x_organization_id => l_to_rsv_rec.organization_id

Line 13704: -- for data sync b/w mtl_demand and mtl_reservations

13700: , x_task_id => l_to_rsv_rec.task_id
13701: /*** End R12 ***/
13702: );
13703: --
13704: -- for data sync b/w mtl_demand and mtl_reservations
13705: inv_rsv_synch.for_update(p_reservation_id => l_orig_rsv_tbl(1).reservation_id, x_return_status => l_return_status, x_msg_count => x_msg_count, x_msg_data => x_msg_data);
13706:
13707: debug_print(' return status after updating row' || l_return_status);
13708:

Line 13830: FROM mtl_reservations

13826:
13827: -- INVCONV - Retrieve secondaries
13828: SELECT primary_reservation_quantity, secondary_reservation_quantity, reservation_quantity
13829: INTO l_primary_rsv_quantity, l_secondary_rsv_quantity, l_rsv_quantity
13830: FROM mtl_reservations
13831: WHERE reservation_id = l_to_rsv_tbl(1).reservation_id;
13832:
13833: l_primary_rsv_quantity := l_primary_rsv_quantity + l_to_rsv_rec.primary_reservation_quantity;
13834:

Line 13878: UPDATE mtl_reservations

13874: -- wont call table handler since only quantities are changed along
13875: -- with the who column this is simpler to read and understand
13876:
13877: -- INVCONV - Incorporate secondary_reservation_quantity which could be null
13878: UPDATE mtl_reservations
13879: SET primary_reservation_quantity = Round((primary_reservation_quantity + l_to_rsv_rec.primary_reservation_quantity),5)
13880: , secondary_reservation_quantity = Round((secondary_reservation_quantity + l_to_rsv_rec.secondary_reservation_quantity),5)
13881: , reservation_quantity = Round((reservation_quantity + l_to_rsv_rec.reservation_quantity),5)
13882: , detailed_quantity = Round(NVL(detailed_quantity, 0) + NVL(l_to_rsv_rec.detailed_quantity, 0),5)

Line 13892: -- for data sync b/w mtl_demand and mtl_reservations

13888: , program_id = l_program_id
13889: , program_update_date = l_date
13890: WHERE reservation_id = l_to_rsv_tbl(1).reservation_id;
13891:
13892: -- for data sync b/w mtl_demand and mtl_reservations
13893: inv_rsv_synch.for_update(p_reservation_id => l_to_rsv_tbl(1).reservation_id, x_return_status => l_return_status, x_msg_count => x_msg_count, x_msg_data => x_msg_data);
13894:
13895: IF l_return_status = fnd_api.g_ret_sts_error THEN
13896: RAISE fnd_api.g_exc_error;

Line 14042: mtl_reservations_pkg.insert_row

14038: -- in INVRSV6B.pls
14039:
14040: l_reservation_id := NULL;
14041: -- INVCONV - Incorporate secondary columns
14042: mtl_reservations_pkg.insert_row
14043: (
14044: x_rowid => l_rowid
14045: , x_reservation_id => l_reservation_id
14046: , x_requirement_date => l_to_rsv_rec.requirement_date

Line 14134: -- insert into mtl_reservations

14130: );
14131:
14132: debug_print(' After call to insert_row : reservation_id : ' || l_reservation_id);
14133:
14134: -- insert into mtl_reservations
14135: x_reservation_id := l_reservation_id;
14136:
14137: -- for data sync b/w mtl_demand and mtl_reservations
14138: inv_rsv_synch.for_insert(p_reservation_id => l_reservation_id, x_return_status => l_return_status, x_msg_count => x_msg_count, x_msg_data => x_msg_data);

Line 14137: -- for data sync b/w mtl_demand and mtl_reservations

14133:
14134: -- insert into mtl_reservations
14135: x_reservation_id := l_reservation_id;
14136:
14137: -- for data sync b/w mtl_demand and mtl_reservations
14138: inv_rsv_synch.for_insert(p_reservation_id => l_reservation_id, x_return_status => l_return_status, x_msg_count => x_msg_count, x_msg_data => x_msg_data);
14139:
14140: IF l_return_status = fnd_api.g_ret_sts_error THEN
14141: RAISE fnd_api.g_exc_error;

Line 14213: l_from_primary_reservation_qty FROM mtl_reservations WHERE

14209:
14210: --check to see if serial are reserved.
14211: BEGIN
14212: SELECT primary_reservation_quantity INTO
14213: l_from_primary_reservation_qty FROM mtl_reservations WHERE
14214: reservation_id = l_orig_rsv_tbl(1).reservation_id;
14215: EXCEPTION
14216: WHEN no_data_found THEN
14217: IF l_debug=1 THEN

Line 14223: l_to_primary_reservation_qty FROM mtl_reservations WHERE

14219: END IF;
14220: END;
14221: BEGIN
14222: SELECT primary_reservation_quantity INTO
14223: l_to_primary_reservation_qty FROM mtl_reservations WHERE
14224: reservation_id = l_to_reservation_id;
14225: EXCEPTION
14226: WHEN no_data_found THEN
14227: IF l_debug=1 THEN

Line 14242: UPDATE mtl_reservations SET serial_reservation_quantity = 0

14238: -- set the serial reservation qty and do nothing.
14239: IF ((l_serial_param = 1) AND (l_total_serials_reserved = 0)) THEN
14240: -- set the serial reservation qty to zero
14241: BEGIN
14242: UPDATE mtl_reservations SET serial_reservation_quantity = 0
14243: WHERE reservation_id = l_orig_rsv_tbl(1).reservation_id;
14244: EXCEPTION
14245: WHEN no_data_found THEN
14246: IF l_debug=1 THEN

Line 15044: UPDATE mtl_reservations SET serial_reservation_quantity

15040: -- update the to serial reservation quantity. dont have
15041: -- to update from as the from record is deleted.
15042:
15043: BEGIN
15044: UPDATE mtl_reservations SET serial_reservation_quantity
15045: = l_total_to_serials_reserved WHERE reservation_id =
15046: l_to_reservation_id;
15047:
15048: EXCEPTION

Line 15129: UPDATE mtl_reservations SET serial_reservation_quantity

15125: RAISE fnd_api.g_exc_error;
15126: END IF;
15127:
15128: BEGIN
15129: UPDATE mtl_reservations SET serial_reservation_quantity
15130: = l_total_to_serials_reserved WHERE reservation_id =
15131: l_orig_rsv_tbl(1).reservation_id;
15132:
15133: EXCEPTION

Line 15265: UPDATE mtl_reservations SET serial_reservation_quantity

15261: RAISE fnd_api.g_exc_error;
15262: END IF;
15263:
15264: BEGIN
15265: UPDATE mtl_reservations SET serial_reservation_quantity
15266: = l_total_to_serials_reserved WHERE reservation_id =
15267: l_to_reservation_id;
15268:
15269: EXCEPTION

Line 15292: UPDATE mtl_reservations SET serial_reservation_quantity

15288: END IF;
15289: END;
15290:
15291: BEGIN
15292: UPDATE mtl_reservations SET serial_reservation_quantity
15293: = l_total_from_serials_reserved WHERE reservation_id =
15294: l_orig_rsv_tbl(1).reservation_id;
15295:
15296: EXCEPTION

Line 15507: UPDATE mtl_reservations SET serial_reservation_quantity

15503: RAISE fnd_api.g_exc_error;
15504: END IF;
15505:
15506: BEGIN
15507: UPDATE mtl_reservations SET serial_reservation_quantity
15508: = l_total_to_serials_reserved WHERE reservation_id =
15509: l_orig_rsv_tbl(1).reservation_id;
15510:
15511: EXCEPTION

Line 15595: UPDATE mtl_reservations SET serial_reservation_quantity

15591: RAISE fnd_api.g_exc_error;
15592: END IF;
15593:
15594: BEGIN
15595: UPDATE mtl_reservations SET serial_reservation_quantity
15596: = l_total_to_serials_reserved WHERE reservation_id =
15597: l_orig_rsv_tbl(1).reservation_id;
15598:
15599: EXCEPTION

Line 15716: UPDATE mtl_reservations SET serial_reservation_quantity

15712: RAISE fnd_api.g_exc_error;
15713: END IF;
15714:
15715: BEGIN
15716: UPDATE mtl_reservations SET serial_reservation_quantity
15717: = l_total_to_serials_reserved WHERE reservation_id =
15718: l_to_reservation_id;
15719:
15720: EXCEPTION

Line 15743: UPDATE mtl_reservations SET serial_reservation_quantity

15739: END IF;
15740: END;
15741:
15742: BEGIN
15743: UPDATE mtl_reservations SET serial_reservation_quantity
15744: = l_total_from_serials_reserved WHERE reservation_id =
15745: l_orig_rsv_tbl(1).reservation_id;
15746:
15747: EXCEPTION

Line 15948: FROM mtl_reservations mr

15944: , orig_demand_source_line_detail
15945: , serial_number
15946: /***** End R12 ***/
15947:
15948: FROM mtl_reservations mr
15949: WHERE demand_source_type_id IN (inv_reservation_global.g_source_type_oe
15950: , inv_reservation_global.g_source_type_internal_ord
15951: , inv_reservation_global.g_source_type_rma
15952: )

Line 16040: FROM mtl_reservations mr

16036: , orig_demand_source_line_detail
16037: , serial_number
16038: /***** End R12 ***/
16039:
16040: FROM mtl_reservations mr
16041: WHERE demand_source_type_id IN (inv_reservation_global.g_source_type_oe
16042: , inv_reservation_global.g_source_type_internal_ord
16043: , inv_reservation_global.g_source_type_rma
16044: )

Line 16133: FROM mtl_reservations mr

16129: , orig_demand_source_line_detail
16130: , serial_number
16131: /***** End R12 ***/
16132:
16133: FROM mtl_reservations mr
16134: WHERE demand_source_type_id IN (inv_reservation_global.g_source_type_oe
16135: , inv_reservation_global.g_source_type_internal_ord
16136: , inv_reservation_global.g_source_type_rma
16137: )

Line 16287: -- MTL_RESERVATIONS record type declarations

16283: l_call_xfr_rsv BOOLEAN := FALSE;
16284: l_reservation_id NUMBER;
16285: l_demand_source_header_id NUMBER;
16286:
16287: -- MTL_RESERVATIONS record type declarations
16288: l_src_rsv inv_reservation_global.mtl_reservation_rec_type;
16289: l_xfr_rsv inv_reservation_global.mtl_reservation_rec_type;
16290: l_serial_number inv_reservation_global.serial_number_tbl_type;
16291:

Line 16371: FROM mtl_reservations

16367: , orig_demand_source_line_detail
16368: , serial_number
16369: /***** End R12 ***/
16370:
16371: FROM mtl_reservations
16372: WHERE organization_id = p_organization_id
16373: AND inventory_item_id = p_inventory_item_id
16374: AND (p_revision IS NULL OR revision = p_revision)
16375: AND demand_source_header_id = l_demand_source_header_id

Line 17353: FROM mtl_reservations mr,

17349: CURSOR serials_outer_lpn_with_item IS
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

Line 17371: FROM mtl_reservations mr,

17367: CURSOR serials_outer_lpn_no_item IS
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

Line 17388: FROM mtl_reservations mr,

17384: CURSOR serials_lpn_with_item IS
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

Line 17404: FROM mtl_reservations mr,

17400: CURSOR serials_lpn_no_item IS
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