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.WMS_DIRECT_SHIP_PVT dependencies on INV_RESERVATION_GLOBAL

Line 4795: l_reservation_record inv_reservation_global.mtl_reservation_rec_type;

4791: x_msg_data OUT NOCOPY VARCHAR2)
4792: RETURN DELIVERY_DETAIL_TAB IS
4793:
4794: --Local Variables
4795: l_reservation_record inv_reservation_global.mtl_reservation_rec_type;
4796: l_delivery_detail_tab DELIVERY_DETAIL_TAB;
4797: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
4798: l_mtl_reservation_tbl_count NUMBER;
4799: l_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;

Line 4797: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;

4793:
4794: --Local Variables
4795: l_reservation_record inv_reservation_global.mtl_reservation_rec_type;
4796: l_delivery_detail_tab DELIVERY_DETAIL_TAB;
4797: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
4798: l_mtl_reservation_tbl_count NUMBER;
4799: l_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
4800: l_detail_tab WSH_UTIL_CORE.ID_TAB_TYPE;
4801: l_return_status VARCHAR2(1);

Line 4799: l_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;

4795: l_reservation_record inv_reservation_global.mtl_reservation_rec_type;
4796: l_delivery_detail_tab DELIVERY_DETAIL_TAB;
4797: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
4798: l_mtl_reservation_tbl_count NUMBER;
4799: l_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
4800: l_detail_tab WSH_UTIL_CORE.ID_TAB_TYPE;
4801: l_return_status VARCHAR2(1);
4802: l_msg_data VARCHAR2(3000);
4803: l_msg_count NUMBER;

Line 4851: l_reservation_record.supply_source_type_id := inv_reservation_global.g_source_type_inv;

4847:
4848: l_reservation_record.demand_source_header_id := p_mso_id;
4849: l_reservation_record.demand_source_line_id := p_source_line_id;
4850: l_reservation_record.demand_source_type_id := get_demand_src_type(l_oe_order_header_id);
4851: l_reservation_record.supply_source_type_id := inv_reservation_global.g_source_type_inv;
4852:
4853: l_mtl_reservation_tbl.DELETE;
4854: FOR l_lpn_rec IN c_lpn_heirarchy(p_lpn_id) LOOP
4855: l_reservation_record.lpn_id := l_lpn_rec.lpn_id;

Line 5318: l_reservation_record inv_reservation_global.mtl_reservation_rec_type;

5314: l_new_delivery_detail_id NUMBER;
5315: l_dummy_num_var NUMBER;
5316:
5317: /* For query reservations */
5318: l_reservation_record inv_reservation_global.mtl_reservation_rec_type;
5319: l_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type; -- bug 4306508
5320: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
5321: l_mtl_reservation_tbl_count NUMBER;
5322: l_reservation_exists_flag VARCHAR2(1);

Line 5319: l_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type; -- bug 4306508

5315: l_dummy_num_var NUMBER;
5316:
5317: /* For query reservations */
5318: l_reservation_record inv_reservation_global.mtl_reservation_rec_type;
5319: l_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type; -- bug 4306508
5320: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
5321: l_mtl_reservation_tbl_count NUMBER;
5322: l_reservation_exists_flag VARCHAR2(1);
5323: l_reserved_lpn NUMBER;

Line 5320: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;

5316:
5317: /* For query reservations */
5318: l_reservation_record inv_reservation_global.mtl_reservation_rec_type;
5319: l_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type; -- bug 4306508
5320: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
5321: l_mtl_reservation_tbl_count NUMBER;
5322: l_reservation_exists_flag VARCHAR2(1);
5323: l_reserved_lpn NUMBER;
5324: l_return_status VARCHAR2(1);

Line 5328: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

5324: l_return_status VARCHAR2(1);
5325: l_msg_count NUMBER;
5326: l_msg_data VARCHAR2(20000);
5327: l_error_code NUMBER;
5328: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
5329: l_outer_lpn outer_lpn%ROWTYPE;
5330: l_inner_lpn inner_lpn%ROWTYPE;
5331: l_mso_id NUMBER;
5332: l_outermost_lpn_id NUMBER;

Line 9376: l_qry_reservation_record inv_reservation_global.mtl_reservation_rec_type;

9372: , ont_pricing_qty_source VARCHAR2(30)
9373: );
9374: l_lpn_content_cur_rec l_lpn_content_cur_rec_typ;
9375:
9376: l_qry_reservation_record inv_reservation_global.mtl_reservation_rec_type;
9377: l_mtl_reservation_tab inv_reservation_global.mtl_reservation_tbl_type;
9378:
9379: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type; --bug#5262108
9380: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type; --bug#5262108

Line 9377: l_mtl_reservation_tab inv_reservation_global.mtl_reservation_tbl_type;

9373: );
9374: l_lpn_content_cur_rec l_lpn_content_cur_rec_typ;
9375:
9376: l_qry_reservation_record inv_reservation_global.mtl_reservation_rec_type;
9377: l_mtl_reservation_tab inv_reservation_global.mtl_reservation_tbl_type;
9378:
9379: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type; --bug#5262108
9380: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type; --bug#5262108
9381: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type; --bug#5262108

Line 9379: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type; --bug#5262108

9375:
9376: l_qry_reservation_record inv_reservation_global.mtl_reservation_rec_type;
9377: l_mtl_reservation_tab inv_reservation_global.mtl_reservation_tbl_type;
9378:
9379: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type; --bug#5262108
9380: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type; --bug#5262108
9381: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type; --bug#5262108
9382:
9383: l_processed_lines_tab processed_lines_tab;

Line 9380: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type; --bug#5262108

9376: l_qry_reservation_record inv_reservation_global.mtl_reservation_rec_type;
9377: l_mtl_reservation_tab inv_reservation_global.mtl_reservation_tbl_type;
9378:
9379: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type; --bug#5262108
9380: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type; --bug#5262108
9381: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type; --bug#5262108
9382:
9383: l_processed_lines_tab processed_lines_tab;
9384: l_order_line_rec order_line_rec;

Line 9381: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type; --bug#5262108

9377: l_mtl_reservation_tab inv_reservation_global.mtl_reservation_tbl_type;
9378:
9379: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type; --bug#5262108
9380: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type; --bug#5262108
9381: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type; --bug#5262108
9382:
9383: l_processed_lines_tab processed_lines_tab;
9384: l_order_line_rec order_line_rec;
9385: l_start_index NUMBER := 1;

Line 9823: AND mr.supply_source_type_id =inv_reservation_global.g_source_type_inv;

9819: IF (c_index =1 OR ( g_lpn_contents_tab(c_index).inventory_item_id <> g_lpn_contents_tab(c_index-1).inventory_item_id) ) THEN
9820: SELECT count(1) INTO l_rsv_count FROM mtl_reservations mr
9821: WHERE mr.organization_id=p_org_id
9822: AND mr.inventory_item_id = g_lpn_contents_tab(c_index).inventory_item_id
9823: AND mr.supply_source_type_id =inv_reservation_global.g_source_type_inv;
9824: END IF;
9825: EXCEPTION
9826: WHEN OTHERS THEN
9827: IF (l_debug = 1) THEN

Line 9871: l_qry_reservation_record.supply_source_type_id := inv_reservation_global.g_source_type_inv;

9867: l_qry_reservation_record.inventory_item_id := g_lpn_contents_tab(c_index).inventory_item_id;
9868: l_qry_reservation_record.revision := g_lpn_contents_tab(c_index).revision;
9869: l_qry_reservation_record.lot_number := g_lpn_contents_tab(c_index).lot_number;
9870: l_qry_reservation_record.lpn_id := g_lpn_contents_tab(c_index).lpn_id;
9871: l_qry_reservation_record.supply_source_type_id := inv_reservation_global.g_source_type_inv;
9872:
9873: inv_reservation_pub.query_reservation(
9874: p_api_version_number => 1.0
9875: , p_init_msg_lst => fnd_api.g_false

Line 10605: l_qry_reservation_record inv_reservation_global.mtl_reservation_rec_type;

10601: , x_msg_count OUT NOCOPY NUMBER
10602: , x_msg_data OUT NOCOPY VARCHAR2
10603: ) IS
10604: -- for query reservation
10605: l_qry_reservation_record inv_reservation_global.mtl_reservation_rec_type;
10606: l_mtl_reservation_tab inv_reservation_global.mtl_reservation_tbl_type;
10607: l_mtl_reservation_tab_temp inv_reservation_global.mtl_reservation_tbl_type;
10608: l_mtl_reservation_tab_count NUMBER;
10609: l_mtl_resv_tab_count_temp NUMBER;

Line 10606: l_mtl_reservation_tab inv_reservation_global.mtl_reservation_tbl_type;

10602: , x_msg_data OUT NOCOPY VARCHAR2
10603: ) IS
10604: -- for query reservation
10605: l_qry_reservation_record inv_reservation_global.mtl_reservation_rec_type;
10606: l_mtl_reservation_tab inv_reservation_global.mtl_reservation_tbl_type;
10607: l_mtl_reservation_tab_temp inv_reservation_global.mtl_reservation_tbl_type;
10608: l_mtl_reservation_tab_count NUMBER;
10609: l_mtl_resv_tab_count_temp NUMBER;
10610: l_return_status VARCHAR2(10);

Line 10607: l_mtl_reservation_tab_temp inv_reservation_global.mtl_reservation_tbl_type;

10603: ) IS
10604: -- for query reservation
10605: l_qry_reservation_record inv_reservation_global.mtl_reservation_rec_type;
10606: l_mtl_reservation_tab inv_reservation_global.mtl_reservation_tbl_type;
10607: l_mtl_reservation_tab_temp inv_reservation_global.mtl_reservation_tbl_type;
10608: l_mtl_reservation_tab_count NUMBER;
10609: l_mtl_resv_tab_count_temp NUMBER;
10610: l_return_status VARCHAR2(10);
10611: l_msg_count NUMBER;

Line 10615: l_resv_rec inv_reservation_global.mtl_reservation_rec_type;

10611: l_msg_count NUMBER;
10612: l_msg_data VARCHAR2(20000);
10613: l_error_code NUMBER;
10614: -- genaral
10615: l_resv_rec inv_reservation_global.mtl_reservation_rec_type;
10616: l_demand_source_header_id NUMBER;
10617: l_demand_source_type_id NUMBER;
10618: l_quantity_reserved NUMBER := 0;
10619: l_sec_qty_reserved NUMBER := 0;

Line 10651: l_old_resv_rec inv_reservation_global.mtl_reservation_rec_type;

10647: l_atr NUMBER;
10648: l_satr NUMBER;
10649: l_grade_code VARCHAR2(150) := NULL;
10650: -- For transfer reservation
10651: l_old_resv_rec inv_reservation_global.mtl_reservation_rec_type;
10652: l_new_resv_rec inv_reservation_global.mtl_reservation_rec_type;
10653: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
10654: l_new_rsv_id NUMBER;
10655: l_current_rsv_rem_qty NUMBER;

Line 10652: l_new_resv_rec inv_reservation_global.mtl_reservation_rec_type;

10648: l_satr NUMBER;
10649: l_grade_code VARCHAR2(150) := NULL;
10650: -- For transfer reservation
10651: l_old_resv_rec inv_reservation_global.mtl_reservation_rec_type;
10652: l_new_resv_rec inv_reservation_global.mtl_reservation_rec_type;
10653: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
10654: l_new_rsv_id NUMBER;
10655: l_current_rsv_rem_qty NUMBER;
10656: l_curr_rsv_rem_sec_qty NUMBER := 0;

Line 10653: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

10649: l_grade_code VARCHAR2(150) := NULL;
10650: -- For transfer reservation
10651: l_old_resv_rec inv_reservation_global.mtl_reservation_rec_type;
10652: l_new_resv_rec inv_reservation_global.mtl_reservation_rec_type;
10653: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
10654: l_new_rsv_id NUMBER;
10655: l_current_rsv_rem_qty NUMBER;
10656: l_curr_rsv_rem_sec_qty NUMBER := 0;
10657: -- For create_reservation

Line 10658: l_reservation_record inv_reservation_global.mtl_reservation_rec_type;

10654: l_new_rsv_id NUMBER;
10655: l_current_rsv_rem_qty NUMBER;
10656: l_curr_rsv_rem_sec_qty NUMBER := 0;
10657: -- For create_reservation
10658: l_reservation_record inv_reservation_global.mtl_reservation_rec_type;
10659: l_quantity_reserved_tmp NUMBER;
10660: l_sec_qty_reserved_tmp NUMBER;
10661: l_reservation_id NUMBER;
10662: -- For Update reservation

Line 10663: l_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;

10659: l_quantity_reserved_tmp NUMBER;
10660: l_sec_qty_reserved_tmp NUMBER;
10661: l_reservation_id NUMBER;
10662: -- For Update reservation
10663: l_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
10664: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
10665: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
10666: l_resv_id NUMBER;
10667: l_other_resv_qty NUMBER;

Line 10664: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;

10660: l_sec_qty_reserved_tmp NUMBER;
10661: l_reservation_id NUMBER;
10662: -- For Update reservation
10663: l_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
10664: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
10665: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
10666: l_resv_id NUMBER;
10667: l_other_resv_qty NUMBER;
10668: l_other_resv_sec_qty NUMBER;

Line 10665: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;

10661: l_reservation_id NUMBER;
10662: -- For Update reservation
10663: l_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
10664: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
10665: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
10666: l_resv_id NUMBER;
10667: l_other_resv_qty NUMBER;
10668: l_other_resv_sec_qty NUMBER;
10669: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

Line 10919: l_qry_reservation_record.supply_source_type_id := inv_reservation_global.g_source_type_inv;

10915: l_demand_source_header_id := inv_salesorder.get_salesorder_for_oeheader(p_order_header_id);
10916: l_qry_reservation_record.demand_source_header_id := l_demand_source_header_id;
10917: l_qry_reservation_record.demand_source_line_id := p_order_line_id;
10918: l_qry_reservation_record.demand_source_type_id := l_demand_source_type_id;
10919: l_qry_reservation_record.supply_source_type_id := inv_reservation_global.g_source_type_inv;
10920:
10921: IF (l_debug = 1) THEN
10922: DEBUG('g_fulfillment_base: ' || g_fulfillment_base, 'Process_Line');
10923: DEBUG('l_overship_case: ' || l_overship_case, 'Process_Line');

Line 12271: l_qry_reservation_record inv_reservation_global.mtl_reservation_rec_type;

12267: WHERE outermost_lpn_id = p_lpn_id
12268: AND organization_id = p_org_id;
12269:
12270: -- query reservations
12271: l_qry_reservation_record inv_reservation_global.mtl_reservation_rec_type;
12272: l_mtl_reservation_tab inv_reservation_global.mtl_reservation_tbl_type;
12273: l_mtl_reservation_tab_count NUMBER;
12274: l_lpn_ids_tab number_table;
12275: l_return_status VARCHAR2(3);

Line 12272: l_mtl_reservation_tab inv_reservation_global.mtl_reservation_tbl_type;

12268: AND organization_id = p_org_id;
12269:
12270: -- query reservations
12271: l_qry_reservation_record inv_reservation_global.mtl_reservation_rec_type;
12272: l_mtl_reservation_tab inv_reservation_global.mtl_reservation_tbl_type;
12273: l_mtl_reservation_tab_count NUMBER;
12274: l_lpn_ids_tab number_table;
12275: l_return_status VARCHAR2(3);
12276: l_msg_count NUMBER;

Line 12307: l_qry_reservation_record.supply_source_type_id := inv_reservation_global.g_source_type_inv;

12303: FOR l_wds_cur IN wds_cur LOOP
12304: l_qry_reservation_record.demand_source_line_id := l_wds_cur.order_line_id;
12305: l_qry_reservation_record.demand_source_header_id := inv_salesorder.get_salesorder_for_oeheader(l_wds_cur.order_header_id);
12306: l_qry_reservation_record.demand_source_type_id := get_demand_src_type(l_wds_cur.order_header_id);
12307: l_qry_reservation_record.supply_source_type_id := inv_reservation_global.g_source_type_inv;
12308:
12309: IF (l_debug = 1) THEN
12310: DEBUG('Before call to query reservation', 'Load_LPN');
12311: END IF;

Line 12509: l_qry_reservation_record inv_reservation_global.mtl_reservation_rec_type;

12505: l_old_tot_lpn_sec_qty NUMBER := g_total_lpn_sec_qty;
12506: l_loaded_lines_rec loaded_lines%ROWTYPE;
12507: l_lpn_cont_rec lpn_content_rec;
12508: -- for query reservation
12509: l_qry_reservation_record inv_reservation_global.mtl_reservation_rec_type;
12510: l_mtl_reservation_tab inv_reservation_global.mtl_reservation_tbl_type;
12511: l_mtl_resv_tab_count NUMBER;
12512: -- general
12513: l_order_line_id NUMBER;

Line 12510: l_mtl_reservation_tab inv_reservation_global.mtl_reservation_tbl_type;

12506: l_loaded_lines_rec loaded_lines%ROWTYPE;
12507: l_lpn_cont_rec lpn_content_rec;
12508: -- for query reservation
12509: l_qry_reservation_record inv_reservation_global.mtl_reservation_rec_type;
12510: l_mtl_reservation_tab inv_reservation_global.mtl_reservation_tbl_type;
12511: l_mtl_resv_tab_count NUMBER;
12512: -- general
12513: l_order_line_id NUMBER;
12514: l_order_header_id NUMBER;

Line 12526: l_reservation_record inv_reservation_global.mtl_reservation_rec_type;

12522: l_max_shippable_sec_qty NUMBER;
12523: l_total_resvd_qty NUMBER;
12524: l_total_resvd_sec_qty NUMBER;
12525: -- For create_reservation
12526: l_reservation_record inv_reservation_global.mtl_reservation_rec_type;
12527: l_quantity_reserved_tmp NUMBER;
12528: l_sec_qty_reserved_tmp NUMBER;
12529: l_reservation_id NUMBER;
12530: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

Line 12530: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

12526: l_reservation_record inv_reservation_global.mtl_reservation_rec_type;
12527: l_quantity_reserved_tmp NUMBER;
12528: l_sec_qty_reserved_tmp NUMBER;
12529: l_reservation_id NUMBER;
12530: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
12531: l_demand_source_header_id NUMBER;
12532: l_demand_source_type_id NUMBER;
12533: -- For Update reservation
12534: l_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;

Line 12534: l_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;

12530: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
12531: l_demand_source_header_id NUMBER;
12532: l_demand_source_type_id NUMBER;
12533: -- For Update reservation
12534: l_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
12535: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
12536: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
12537: l_resv_id NUMBER;
12538: l_qty_updt_resv NUMBER;

Line 12535: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;

12531: l_demand_source_header_id NUMBER;
12532: l_demand_source_type_id NUMBER;
12533: -- For Update reservation
12534: l_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
12535: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
12536: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
12537: l_resv_id NUMBER;
12538: l_qty_updt_resv NUMBER;
12539: l_sec_qty_updt_resv NUMBER;

Line 12536: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;

12532: l_demand_source_type_id NUMBER;
12533: -- For Update reservation
12534: l_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
12535: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
12536: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
12537: l_resv_id NUMBER;
12538: l_qty_updt_resv NUMBER;
12539: l_sec_qty_updt_resv NUMBER;
12540: l_qty_overship NUMBER;

Line 12619: l_qry_reservation_record.supply_source_type_id := inv_reservation_global.g_source_type_inv;

12615: l_qry_reservation_record.lpn_id := l_lpn_cont_rec.lpn_id;
12616: l_qry_reservation_record.inventory_item_id := l_lpn_cont_rec.inventory_item_id;
12617: l_qry_reservation_record.revision := l_lpn_cont_rec.revision;
12618: l_qry_reservation_record.lot_number := l_lpn_cont_rec.lot_number;
12619: l_qry_reservation_record.supply_source_type_id := inv_reservation_global.g_source_type_inv;
12620:
12621: IF (l_debug = 1) THEN
12622: DEBUG('Before call to query reservation', 'Perform_Overship_Distribution');
12623: END IF;