APPS.INV_PICK_RELEASE_PVT dependencies on WSH_INV_DELIVERY_DETAILS_V

Line 459: , p_demand_info IN wsh_inv_delivery_details_v%ROWTYPE

455: PROCEDURE process_reservations(
456: x_return_status OUT NOCOPY VARCHAR2
457: , x_msg_count OUT NOCOPY NUMBER
458: , x_msg_data OUT NOCOPY VARCHAR2
459: , p_demand_info IN wsh_inv_delivery_details_v%ROWTYPE
460: , p_mo_line_rec IN inv_move_order_pub.trolin_rec_type
461: , p_mso_line_id IN NUMBER
462: , p_demand_source_type IN VARCHAR2
463: , p_demand_source_name IN VARCHAR2

Line 1441: , p_demand_info IN wsh_inv_delivery_details_v%ROWTYPE

1437: , x_pick_slip_number OUT NOCOPY NUMBER
1438: , x_ready_to_print OUT NOCOPY VARCHAR2
1439: , x_call_mode OUT NOCOPY VARCHAR2
1440: , p_mo_line_rec IN OUT NOCOPY inv_move_order_pub.trolin_rec_type
1441: , p_demand_info IN wsh_inv_delivery_details_v%ROWTYPE
1442: , p_grouping_rule_id IN NUMBER
1443: , p_pick_slip_mode IN VARCHAR2
1444: , p_print_mode IN VARCHAR2
1445: ) IS

Line 1968: l_demand_info wsh_inv_delivery_details_v%ROWTYPE;

1964: ) IS
1965: -- Define local variables
1966: l_api_version CONSTANT NUMBER := 1.0;
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.

Line 2125: FROM wsh_inv_delivery_details_v

2121: /* BENCHMARK - don't need to join to OE_ORDER_LINES_ALL or RA_CUSTOMERS,
2122: since we don't use customer number or shipment number in this code
2123: SELECT *
2124: INTO l_demand_info
2125: FROM wsh_inv_delivery_details_v
2126: WHERE move_order_line_id = p_mo_line_rec.line_id
2127: AND move_order_line_id IS NOT NULL
2128: AND released_status = 'S';
2129: */