APPS.INV_PICK_RELEASE_PVT dependencies on WSH_INV_DELIVERY_DETAILS_V

Line 495: , p_demand_info IN wsh_inv_delivery_details_v%ROWTYPE

491: PROCEDURE process_reservations(
492: x_return_status OUT NOCOPY VARCHAR2
493: , x_msg_count OUT NOCOPY NUMBER
494: , x_msg_data OUT NOCOPY VARCHAR2
495: , p_demand_info IN wsh_inv_delivery_details_v%ROWTYPE
496: , p_mo_line_rec IN inv_move_order_pub.trolin_rec_type
497: , p_mso_line_id IN NUMBER
498: , p_demand_source_type IN VARCHAR2
499: , p_demand_source_name IN VARCHAR2

Line 1631: , p_demand_info IN wsh_inv_delivery_details_v%ROWTYPE

1627: , x_pick_slip_number OUT NOCOPY NUMBER
1628: , x_ready_to_print OUT NOCOPY VARCHAR2
1629: , x_call_mode OUT NOCOPY VARCHAR2
1630: , p_mo_line_rec IN OUT NOCOPY inv_move_order_pub.trolin_rec_type
1631: , p_demand_info IN wsh_inv_delivery_details_v%ROWTYPE
1632: , p_grouping_rule_id IN NUMBER
1633: , p_pick_slip_mode IN VARCHAR2
1634: , p_print_mode IN VARCHAR2
1635: ) IS

Line 2265: l_demand_info wsh_inv_delivery_details_v%ROWTYPE;

2261: ) IS
2262: -- Define local variables
2263: l_api_version CONSTANT NUMBER := 1.0;
2264: l_api_name CONSTANT VARCHAR2(30) := 'Process_Line';
2265: l_demand_info wsh_inv_delivery_details_v%ROWTYPE;
2266: -- All of the demand source and delivery information for the line which is being processed
2267: -- A local copy of the move order line record
2268: l_demand_rsvs_ordered inv_reservation_global.mtl_reservation_tbl_type;
2269: -- The above table in descending order of detail, and with any non-matching records filtered out.

Line 2432: FROM wsh_inv_delivery_details_v

2428: /* BENCHMARK - don't need to join to OE_ORDER_LINES_ALL or RA_CUSTOMERS,
2429: since we don't use customer number or shipment number in this code
2430: SELECT *
2431: INTO l_demand_info
2432: FROM wsh_inv_delivery_details_v
2433: WHERE move_order_line_id = p_mo_line_rec.line_id
2434: AND move_order_line_id IS NOT NULL
2435: AND released_status = 'S';
2436: */