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 WSH_DELIVERY_DETAILS

Line 163: FROM wsh_delivery_details

159: source_header_id,
160: source_line_set_id,
161: source_code,
162: source_line_id
163: FROM wsh_delivery_details
164: WHERE move_order_line_id = p_mo_line_id;
165:
166: l_detail_info c_detail_info%ROWTYPE;
167: l_minmaxinrectype WSH_DETAILS_VALIDATIONS.MinMaxInRecType;

Line 170: l_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE;

166: l_detail_info c_detail_info%ROWTYPE;
167: l_minmaxinrectype WSH_DETAILS_VALIDATIONS.MinMaxInRecType;
168: l_minmaxinoutrectype WSH_DETAILS_VALIDATIONS.MinMaxInOutRecType;
169: l_minmaxoutrectype WSH_DETAILS_VALIDATIONS.MinMaxOutRecType;
170: l_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE;
171: l_min_quantity NUMBER;
172: l_max_quantity NUMBER;
173: l_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE;
174: l_min_quantity2 NUMBER;

Line 173: l_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE;

169: l_minmaxoutrectype WSH_DETAILS_VALIDATIONS.MinMaxOutRecType;
170: l_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE;
171: l_min_quantity NUMBER;
172: l_max_quantity NUMBER;
173: l_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE;
174: l_min_quantity2 NUMBER;
175: l_max_quantity2 NUMBER;
176: l_req_quantity NUMBER;
177: l_move_order_type NUMBER;

Line 2441: SELECT /+index (WDD WSH_DELIVERY_DETAILS_N7)/

2437: /* Bug 5570553 added the index hint with the suggestion of apps performance team */
2438: -- Bug8757642. Added p_wave_simulation_mode with default vale 'N' for WavePlanning Project.
2439: -- This project is available only in for R121 and mainline. To retain dual maintenance INV code changes are made in branchline, however it will not affect any existing flow.
2440: IF p_wave_simulation_mode = 'N' THEN
2441: SELECT /*+index (WDD WSH_DELIVERY_DETAILS_N7)*/
2442: wdd.source_header_id oe_header_id,
2443: wts.stop_id trip_stop_id,
2444: wdd.source_line_id oe_line_id,
2445: wda.delivery_id shipping_delivery_id,

Line 2457: FROM wsh_delivery_details wdd, wsh_delivery_assignments_v wda,

2453: wdd.move_order_line_id move_order_line_id,
2454: wdd.released_status,
2455: wdd.delivery_detail_id
2456: INTO l_demand_info
2457: FROM wsh_delivery_details wdd, wsh_delivery_assignments_v wda,
2458: wsh_new_deliveries wnd, wsh_delivery_legs wlg, wsh_trip_stops wts
2459: WHERE wnd.delivery_id(+) = wda.delivery_id
2460: AND wlg.delivery_id(+) = wnd.delivery_id
2461: AND wts.stop_id(+) = wlg.pick_up_stop_id

Line 2472: SELECT /+index (WDD WSH_DELIVERY_DETAILS_N7)/

2468: AND wdd.move_order_line_Id IS NOT NULL
2469: --AND nvl(wdd.shipment_direction,'O') in ( 'O' , 'IO')
2470: AND wdd.released_status = 'S';
2471: ELSIF p_wave_simulation_mode = 'Y' THEN
2472: SELECT /*+index (WDD WSH_DELIVERY_DETAILS_N7)*/
2473: wdd.source_header_id oe_header_id,
2474: wdd.source_line_id oe_line_id
2475: INTO l_demand_info.oe_header_id, l_demand_info.oe_line_id
2476: FROM wsh_delivery_details wdd

Line 2476: FROM wsh_delivery_details wdd

2472: SELECT /*+index (WDD WSH_DELIVERY_DETAILS_N7)*/
2473: wdd.source_header_id oe_header_id,
2474: wdd.source_line_id oe_line_id
2475: INTO l_demand_info.oe_header_id, l_demand_info.oe_line_id
2476: FROM wsh_delivery_details wdd
2477: WHERE wdd.move_order_line_id = p_mo_line_rec.line_id;
2478: end if;
2479: EXCEPTION
2480: WHEN NO_DATA_FOUND THEN