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_PICK_RELEASE_PVT dependencies on INV_RESERVATION_GLOBAL

Line 267: , p_res_rec IN inv_reservation_global.mtl_reservation_rec_type

263: -- This function returns 2 if the reservation does not match the move order
264: -- line, 1 otherwise.
265: FUNCTION reservation_matches(
266: p_mo_line_rec IN inv_move_order_pub.trolin_rec_type
267: , p_res_rec IN inv_reservation_global.mtl_reservation_rec_type
268: )
269: RETURN NUMBER IS
270: l_mo_from_sub VARCHAR2(10);
271: l_mo_from_loc NUMBER;

Line 465: , x_demand_rsvs_ordered OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type

461: , p_mso_line_id IN NUMBER
462: , p_demand_source_type IN VARCHAR2
463: , p_demand_source_name IN VARCHAR2
464: , p_allow_partial_pick IN VARCHAR2 DEFAULT fnd_api.g_true
465: , x_demand_rsvs_ordered OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
466: , x_rsv_qty_available OUT NOCOPY NUMBER
467: , x_rsv_qty2_available OUT NOCOPY NUMBER
468: ) IS
469: -- A local copy of the move order line record

Line 470: l_qry_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

466: , x_rsv_qty_available OUT NOCOPY NUMBER
467: , x_rsv_qty2_available OUT NOCOPY NUMBER
468: ) IS
469: -- A local copy of the move order line record
470: l_qry_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
471: -- Record for querying up matching reservations for the move order line
472: l_qry_rsv_rec_by_id inv_reservation_global.mtl_reservation_rec_type;
473: -- Record for querying up a single reservation record by the reservation ID
474: l_update_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

Line 472: l_qry_rsv_rec_by_id inv_reservation_global.mtl_reservation_rec_type;

468: ) IS
469: -- A local copy of the move order line record
470: l_qry_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
471: -- Record for querying up matching reservations for the move order line
472: l_qry_rsv_rec_by_id inv_reservation_global.mtl_reservation_rec_type;
473: -- Record for querying up a single reservation record by the reservation ID
474: l_update_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
475: -- Record for updating reservations
476: l_demand_reservations inv_reservation_global.mtl_reservation_tbl_type;

Line 474: l_update_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

470: l_qry_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
471: -- Record for querying up matching reservations for the move order line
472: l_qry_rsv_rec_by_id inv_reservation_global.mtl_reservation_rec_type;
473: -- Record for querying up a single reservation record by the reservation ID
474: l_update_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
475: -- Record for updating reservations
476: l_demand_reservations inv_reservation_global.mtl_reservation_tbl_type;
477: -- The table of reservations for the line's demand source
478: l_demand_rsvs_ordered inv_reservation_global.mtl_reservation_tbl_type;

Line 476: l_demand_reservations inv_reservation_global.mtl_reservation_tbl_type;

472: l_qry_rsv_rec_by_id inv_reservation_global.mtl_reservation_rec_type;
473: -- Record for querying up a single reservation record by the reservation ID
474: l_update_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
475: -- Record for updating reservations
476: l_demand_reservations inv_reservation_global.mtl_reservation_tbl_type;
477: -- The table of reservations for the line's demand source
478: l_demand_rsvs_ordered inv_reservation_global.mtl_reservation_tbl_type;
479: -- The above table in descending order of detail, and with any non-matching records filtered out.
480: l_reservation_count NUMBER; -- The number of reservations for the line

Line 478: l_demand_rsvs_ordered inv_reservation_global.mtl_reservation_tbl_type;

474: l_update_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
475: -- Record for updating reservations
476: l_demand_reservations inv_reservation_global.mtl_reservation_tbl_type;
477: -- The table of reservations for the line's demand source
478: l_demand_rsvs_ordered inv_reservation_global.mtl_reservation_tbl_type;
479: -- The above table in descending order of detail, and with any non-matching records filtered out.
480: l_reservation_count NUMBER; -- The number of reservations for the line
481: l_all_reservation_count NUMBER; -- The number of reservations for the line
482: l_reservation_count_by_id NUMBER; -- The number of reservations returned when querying by reservation ID (should be 1)

Line 535: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

531: l_non_inv_sec_reservation_qty NUMBER := 0;
532: l_secondary_reservation_qty NUMBER := 0;
533:
534: l_staged_flag VARCHAR2(1);
535: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
536: l_revision_control_code NUMBER;
537: l_lot_control_code NUMBER;
538: l_lot_divisible_flag VARCHAR2(1);
539: l_serial_control_code NUMBER;

Line 552: l_new_demand_rsvs_ordered INV_Reservation_GLOBAL.MTL_RESERVATION_TBL_TYPE;

548: l_index NUMBER;
549: l_new_rsv_quantity NUMBER;
550:
551: -- Bug 2972143
552: l_new_demand_rsvs_ordered INV_Reservation_GLOBAL.MTL_RESERVATION_TBL_TYPE;
553:
554: -- Bug 4171297
555: l_order_line_qty_unconv NUMBER; -- The order line quantity, in the order line uom.
556: l_order_line_qty NUMBER; -- The order line quantity, converted in the primary uom.

Line 561: l_rsv_serials inv_reservation_global.serial_number_tbl_type;

557: l_order_line_uom VARCHAR2(3); -- The UOM in which the order line quantity is specified.
558: l_primary_staged_qty NUMBER := 0; -- Sum of staged reservation qty for this order line.
559: l_orig_quantity_to_detail NUMBER;
560:
561: l_rsv_serials inv_reservation_global.serial_number_tbl_type;
562: l_pri_sec_conv NUMBER;
563:
564: CURSOR get_rsv_serials (rsv_id NUMBER) IS
565: SELECT reservation_id, serial_number

Line 591: AND supply_source_type_id <> INV_Reservation_GLOBAL.g_source_type_inv

587: , g_item_sec_non_inv_rsv(p_mo_line_rec.inventory_item_id)
588: FROM mtl_reservations
589: WHERE organization_id = p_mo_line_rec.organization_id
590: AND inventory_item_id = p_mo_line_rec.inventory_item_id
591: AND supply_source_type_id <> INV_Reservation_GLOBAL.g_source_type_inv
592: AND demand_source_line_detail IS NULL;
593: END IF;
594:
595: -- Bug 4494038: exclude crossdock reservations

Line 606: AND supply_source_type_id <> INV_Reservation_GLOBAL.g_source_type_inv

602: WHERE demand_source_line_id = p_demand_info.oe_line_id
603: AND organization_id = p_mo_line_rec.organization_id
604: AND inventory_item_id = p_mo_line_rec.inventory_item_id
605: AND demand_source_type_id = p_demand_source_type
606: AND supply_source_type_id <> INV_Reservation_GLOBAL.g_source_type_inv
607: AND demand_source_line_detail IS NULL;
608: ELSE
609: l_non_inv_reservations_qty := 0;
610: l_non_inv_sec_reservation_qty := 0;

Line 630: l_qry_rsv_rec.supply_source_type_id := inv_reservation_global.g_source_type_inv;

626: l_qry_rsv_rec.demand_source_type_id := p_demand_source_type;
627: l_qry_rsv_rec.demand_source_header_id := nvl(p_mso_line_id,fnd_api.g_miss_num);
628: l_qry_rsv_rec.demand_source_line_id := p_demand_info.oe_line_id;
629: l_qry_rsv_rec.demand_source_name := nvl(p_demand_source_name,fnd_api.g_miss_char);
630: l_qry_rsv_rec.supply_source_type_id := inv_reservation_global.g_source_type_inv;
631: inv_reservation_pub.query_reservation(
632: p_api_version_number => 1.0
633: , p_init_msg_lst => fnd_api.g_false
634: , x_return_status => l_api_return_status

Line 638: --, p_cancel_order_mode => inv_reservation_global.g_cancel_order_yes

634: , x_return_status => l_api_return_status
635: , x_msg_count => x_msg_count
636: , x_msg_data => x_msg_data
637: , p_query_input => l_qry_rsv_rec
638: --, p_cancel_order_mode => inv_reservation_global.g_cancel_order_yes
639: , x_mtl_reservation_tbl => l_demand_reservations
640: , x_mtl_reservation_tbl_count => l_reservation_count
641: , x_error_code => l_api_error_code
642: );

Line 765: IF(l_lot_control_code = inv_reservation_global.g_lot_control_yes AND INV_CACHE.item_rec.lot_divisible_flag <> 'Y') THEN

761: l_revision_control_code:= INV_CACHE.item_rec.revision_qty_control_code;
762: l_lot_control_code:= INV_CACHE.item_rec.lot_control_code;
763: l_serial_control_code:= INV_CACHE.item_rec.serial_number_control_code;
764:
765: IF(l_lot_control_code = inv_reservation_global.g_lot_control_yes AND INV_CACHE.item_rec.lot_divisible_flag <> 'Y') THEN
766: l_lot_divisible_flag := 'N';
767: ELSE
768: l_lot_divisible_flag := 'Y';
769: END IF;

Line 1190: --INV_Reservation_Global.g_source_type_oe; -- order entry

1186: l_update_rsv_rec.organization_id := p_mo_line_rec.organization_id;
1187: l_update_rsv_rec.inventory_item_id :=p_mo_line_rec.inventory_item_id;
1188: l_update_rsv_rec.demand_source_type_id := p_demand_source_type;
1189: l_update_rsv_rec.demand_source_name := p_demand_source_name;
1190: --INV_Reservation_Global.g_source_type_oe; -- order entry
1191: l_update_rsv_rec.demand_source_header_id := p_mso_line_id;
1192: l_update_rsv_rec.demand_source_line_id := p_demand_info.oe_line_id;
1193: l_update_rsv_rec.demand_source_delivery := NULL;
1194: l_update_rsv_rec.primary_uom_code := l_primary_uom;

Line 1207: l_update_rsv_rec.supply_source_type_id := inv_reservation_global.g_source_type_inv;

1203: --l_update_rsv_rec.grade_code := l_grade_code;
1204: l_update_rsv_rec.autodetail_group_id := NULL;
1205: l_update_rsv_rec.external_source_code := NULL;
1206: l_update_rsv_rec.external_source_line_id := NULL;
1207: l_update_rsv_rec.supply_source_type_id := inv_reservation_global.g_source_type_inv;
1208: l_update_rsv_rec.supply_source_header_id := NULL;
1209: l_update_rsv_rec.supply_source_line_id := NULL;
1210: l_update_rsv_rec.supply_source_name := NULL;
1211: l_update_rsv_rec.supply_source_line_detail := NULL;

Line 1971: l_demand_rsvs_ordered inv_reservation_global.mtl_reservation_tbl_type;

1967: l_api_name CONSTANT VARCHAR2(30) := 'Process_Line';
1968: l_demand_info wsh_inv_delivery_details_v%ROWTYPE;
1969: -- All of the demand source and delivery information for the line which is being processed
1970: -- A local copy of the move order line record
1971: l_demand_rsvs_ordered inv_reservation_global.mtl_reservation_tbl_type;
1972: -- The above table in descending order of detail, and with any non-matching records filtered out.
1973: l_mso_header_id NUMBER; -- The MTL_SALES_ORDERS header ID, which should be derived from the OE header ID
1974: l_res_ordered_index NUMBER; -- An index to the elements of the ordered and filtered reservations table.
1975: l_quantity_to_detail NUMBER; -- The quantity for the move order line which should be detailed.

Line 1978: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

1974: l_res_ordered_index NUMBER; -- An index to the elements of the ordered and filtered reservations table.
1975: l_quantity_to_detail NUMBER; -- The quantity for the move order line which should be detailed.
1976: l_primary_uom VARCHAR2(3); -- The primary UOM for the item
1977: l_secondary_uom VARCHAR2(3); -- The primary UOM for the item
1978: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
1979: l_quantity_detailed NUMBER; -- The quantity for the current move order which was detailed (in primary UOM)
1980: l_sec_quantity_detailed NUMBER; -- The quantity for the current move order which was detailed (in secondary UOM)
1981: l_num_detail_recs NUMBER; -- The number of move order line details for this move order line.
1982: l_partially_detailed NUMBER; -- A flag indicating whether the line could only be partially picked. If this flag is

Line 2038: l_original_rsv_record inv_reservation_global.mtl_reservation_rec_type ; -- for bug 7253296

2034: l_min_tolerance NUMBER;
2035: l_revision VARCHAR2(3);
2036:
2037: l_reduce_rsv_qty NUMBER := 0; -- bug 6264551
2038: l_original_rsv_record inv_reservation_global.mtl_reservation_rec_type ; -- for bug 7253296
2039: l_to_rsv_record inv_reservation_global.mtl_reservation_rec_type ; -- for bug 7253296
2040:
2041: -- Added following variables for Bug 7377744
2042: l_sec_qty_available_to_reserve NUMBER; -- The quantity which can still be reserved.

Line 2039: l_to_rsv_record inv_reservation_global.mtl_reservation_rec_type ; -- for bug 7253296

2035: l_revision VARCHAR2(3);
2036:
2037: l_reduce_rsv_qty NUMBER := 0; -- bug 6264551
2038: l_original_rsv_record inv_reservation_global.mtl_reservation_rec_type ; -- for bug 7253296
2039: l_to_rsv_record inv_reservation_global.mtl_reservation_rec_type ; -- for bug 7253296
2040:
2041: -- Added following variables for Bug 7377744
2042: l_sec_qty_available_to_reserve NUMBER; -- The quantity which can still be reserved.
2043: l_sec_qty_on_hand NUMBER; -- The org-wide quantity on-hand

Line 2346: IF (l_lot_control_code = inv_reservation_global.g_lot_control_yes AND INV_CACHE.item_rec.lot_divisible_flag <> 'Y') THEN

2342: END IF; -- The item is reservable
2343:
2344: l_lot_control_code:= INV_CACHE.item_rec.lot_control_code;
2345:
2346: IF (l_lot_control_code = inv_reservation_global.g_lot_control_yes AND INV_CACHE.item_rec.lot_divisible_flag <> 'Y') THEN
2347: l_lot_divisible_flag := 'N';
2348: ELSE
2349: l_lot_divisible_flag := 'Y';
2350: END IF;