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_SHIPPING_TRANSACTION_PUB dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 171: FROM wsh_new_deliveries_ob_grp_v wnd, wsh_delivery_assignments_v wda,wsh_delivery_details_ob_grp_v wdd

167: OPEN x_deliveryLOV for
168: SELECT distinct wnd.name, wnd.delivery_id, wnd.gross_weight, wnd.weight_uom_code,
169: wnd.waybill,
170: GET_SHIPMETHOD_MEANING(wnd.ship_method_code)
171: FROM wsh_new_deliveries_ob_grp_v wnd, wsh_delivery_assignments_v wda,wsh_delivery_details_ob_grp_v wdd
172: WHERE wda.delivery_Detail_id = wdd.delivery_Detail_id
173: AND wda.delivery_id = wnd.delivery_id
174: and ( wdd.released_status = 'Y'
175: OR (wdd.released_status='X' and wdd.source_code='RTV') --RTV Change 16197273

Line 199: FROM wsh_new_deliveries_ob_grp_v wnd, wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd

195: OPEN x_deliveryLOV for
196: SELECT distinct wnd.name, wnd.delivery_id, wnd.gross_weight, wnd.weight_uom_code,
197: wnd.waybill,
198: GET_SHIPMETHOD_MEANING(wnd.ship_method_code)
199: FROM wsh_new_deliveries_ob_grp_v wnd, wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd
200: WHERE wda.delivery_Detail_id = wdd.delivery_Detail_id
201: AND wda.delivery_id = wnd.delivery_id
202: and wdd.organization_id = p_organization_id
203: and wnd.name like (p_delivery_name);

Line 217: from wsh_delivery_assignments_v wda

213: GET_SHIPMETHOD_MEANING(wnd.ship_method_code)
214: from wsh_new_deliveries_ob_grp_v wnd
215: where wnd.delivery_id IN -- bug 2326192
216: ( select wda.delivery_id
217: from wsh_delivery_assignments_v wda
218: where parent_delivery_detail_id =
219: ( select wdd.delivery_detail_id
220: from wsh_delivery_details_ob_grp_v wdd
221: where wdd.lpn_id = p_lpn_id

Line 236: wsh_delivery_assignments wda

232: FROM wsh_new_deliveries wnd
233: WHERE wnd.delivery_id IN
234: ( SELECT wda.delivery_id
235: FROM wsh_delivery_details wdd,
236: wsh_delivery_assignments wda
237: WHERE wdd.lpn_id = p_lpn_id
238: AND wdd.organization_id = p_organization_id
239: AND wda.parent_delivery_detail_id = wdd.delivery_detail_id
240: -- AND wdd.released_status = 'X' -- For LPN reuse ER : 6845650 -- Commented to display the closed deliveries for bug#13990462

Line 255: wsh_delivery_assignments_v wda,

251: BEGIN
252: OPEN x_deliveryLineLOV for
253: SELECT wdd.delivery_detail_id
254: FROM wsh_delivery_details_ob_grp_v wdd,
255: wsh_delivery_assignments_v wda,
256: wsh_new_deliveries_ob_grp_v wnd
257: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
258: AND wda.delivery_id = wnd.delivery_id
259: AND wnd.delivery_id = p_delivery_id

Line 352: wsh_delivery_assignments_v da, mtl_system_items_vl msiv

348: REQUESTED_QUANTITY2,
349: PICKED_QUANTITY2,
350: SHIPPED_QUANTITY2
351: FROM wsh_new_deliveries_ob_grp_v del, wsh_delivery_details_ob_grp_v dd,
352: wsh_delivery_assignments_v da, mtl_system_items_vl msiv
353: WHERE da.delivery_id = del.delivery_id
354: AND da.delivery_detail_id = dd.delivery_detail_id
355: AND ( dd.inventory_item_id = p_inventory_item_id or p_inventory_item_id = -1 )
356: AND NVL( dd.inv_interfaced_flag, 'N') = 'N'

Line 377: wsh_delivery_assignments_v da,

373: dd.picked_quantity,
374: dd.shipped_quantity
375: FROM wsh_new_deliveries_ob_grp_v del,
376: wsh_delivery_details_ob_grp_v dd,
377: wsh_delivery_assignments_v da,
378: mtl_system_items_vl msiv
379: WHERE da.delivery_id = del.delivery_id
380: AND da.delivery_detail_id = dd.delivery_detail_id
381: AND ( dd.inventory_item_id = p_inventory_item_id

Line 407: wsh_delivery_assignments_v da,

403: cursor item_name is
404: select msik.concatenated_segments
405: from wsh_new_deliveries_ob_grp_v del,
406: wsh_delivery_details_ob_grp_v dd,
407: wsh_delivery_assignments_v da,
408: mtl_system_items_kfv msik
409: where da.delivery_id = del.delivery_id
410: AND da.delivery_detail_id = dd.delivery_detail_id
411: AND del.delivery_id = p_delivery_id

Line 616: from wsh_delivery_assignments_v da,wsh_delivery_details_ob_grp_v dd

612: x_msg_count OUT NOCOPY NUMBER) IS
613:
614: cursor delivery_details_ids(p_delivery_id NUMBER) is
615: select dd.delivery_detail_id
616: from wsh_delivery_assignments_v da,wsh_delivery_details_ob_grp_v dd
617: where da.delivery_id = p_delivery_id
618: and da.delivery_detail_id = dd.delivery_detail_id
619: and dd.container_flag <>'Y';
620:

Line 623: from wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd2

619: and dd.container_flag <>'Y';
620:
621: cursor lpn_csr(p_delivery_detail_id in NUMBER) is
622: select wdd.delivery_detail_id, wda.delivery_assignment_id,wda2.delivery_assignment_id
623: from wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd2
624: , wsh_delivery_assignments_v wda2
625: where wdd.delivery_detail_id = wda.parent_delivery_detail_id
626: and wda.delivery_detail_id = wdd2.delivery_detail_id
627: and wdd2.delivery_detail_id = p_delivery_detail_id

Line 624: , wsh_delivery_assignments_v wda2

620:
621: cursor lpn_csr(p_delivery_detail_id in NUMBER) is
622: select wdd.delivery_detail_id, wda.delivery_assignment_id,wda2.delivery_assignment_id
623: from wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd2
624: , wsh_delivery_assignments_v wda2
625: where wdd.delivery_detail_id = wda.parent_delivery_detail_id
626: and wda.delivery_detail_id = wdd2.delivery_detail_id
627: and wdd2.delivery_detail_id = p_delivery_detail_id
628: and wda2.delivery_detail_id = wdd.delivery_detail_id;

Line 663: FROM wsh_delivery_assignments_v wda

659:
660: CURSOR lpn_cur(p_delivery_id NUMBER) IS
661: SELECT wdd.lpn_id, wdd.organization_id
662: FROM (SELECT delivery_detail_id
663: FROM wsh_delivery_assignments_v wda
664: WHERE wda.delivery_id = p_delivery_id ) wda
665: , wsh_delivery_details_ob_grp_v wdd
666: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
667: AND wdd.lpn_id IS NOT NULL;

Line 911: from wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd2

907: WHERE dd.delivery_detail_id = p_delivery_detail_id;
908:
909: cursor lpn_csr(p_delivery_detail_id in NUMBER) is
910: select wdd.delivery_detail_id, wda.delivery_assignment_id,wda2.delivery_assignment_id
911: from wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd2
912: , wsh_delivery_assignments_v wda2
913: where wdd.delivery_detail_id = wda.parent_delivery_detail_id
914: and wda.delivery_detail_id = wdd2.delivery_detail_id
915: and wdd2.delivery_detail_id = p_delivery_detail_id

Line 912: , wsh_delivery_assignments_v wda2

908:
909: cursor lpn_csr(p_delivery_detail_id in NUMBER) is
910: select wdd.delivery_detail_id, wda.delivery_assignment_id,wda2.delivery_assignment_id
911: from wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd2
912: , wsh_delivery_assignments_v wda2
913: where wdd.delivery_detail_id = wda.parent_delivery_detail_id
914: and wda.delivery_detail_id = wdd2.delivery_detail_id
915: and wdd2.delivery_detail_id = p_delivery_detail_id
916: and wda2.delivery_detail_id = wdd.delivery_detail_id;

Line 1230: from wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd2

1226: WHERE dd.delivery_detail_id = p_delivery_detail_id;
1227:
1228: cursor lpn_csr(p_delivery_detail_id in NUMBER) is
1229: select wdd.delivery_detail_id, wda.delivery_assignment_id,wda2.delivery_assignment_id
1230: from wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd2
1231: , wsh_delivery_assignments_v wda2
1232: where wdd.delivery_detail_id = wda.parent_delivery_detail_id
1233: and wda.delivery_detail_id = wdd2.delivery_detail_id
1234: and wdd2.delivery_detail_id = p_delivery_detail_id

Line 1231: , wsh_delivery_assignments_v wda2

1227:
1228: cursor lpn_csr(p_delivery_detail_id in NUMBER) is
1229: select wdd.delivery_detail_id, wda.delivery_assignment_id,wda2.delivery_assignment_id
1230: from wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd2
1231: , wsh_delivery_assignments_v wda2
1232: where wdd.delivery_detail_id = wda.parent_delivery_detail_id
1233: and wda.delivery_detail_id = wdd2.delivery_detail_id
1234: and wdd2.delivery_detail_id = p_delivery_detail_id
1235: and wda2.delivery_detail_id = wdd.delivery_detail_id;

Line 1989: wsh_delivery_assignments_v da

1985:
1986: CURSOR c_delivery_details is
1987: SELECT dd.*
1988: from wsh_delivery_details_ob_grp_v dd,
1989: wsh_delivery_assignments_v da
1990: where
1991: da.delivery_id = p_delivery_id
1992: and da.delivery_detail_id = dd.delivery_detail_id
1993: and dd.lpn_id is null;

Line 1999: wsh_delivery_assignments wda

1995: CURSOR get_lpn_id_wdd(l_delivery_detail_id NUMBER) IS --16482236
1996: SELECT wdd1.lpn_id
1997: from wsh_delivery_details wdd1,
1998: wsh_delivery_details wdd2,
1999: wsh_delivery_assignments wda
2000: WHERE wdd2.delivery_detail_id = l_delivery_detail_id
2001: AND wdd2.delivery_detail_id = wda.delivery_detail_id
2002: AND wda.parent_delivery_detail_id IS NOT NULL
2003: AND wda.parent_delivery_detail_id = wdd1.delivery_detail_id

Line 2140: wsh_delivery_assignments_v wda

2136:
2137: CURSOR specified_ship_set IS
2138: SELECT wdd.ship_set_id
2139: FROM wsh_delivery_details_ob_grp_v wdd,
2140: wsh_delivery_assignments_v wda
2141: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
2142: AND EXISTS (SELECT 'x'
2143: FROM wsh_delivery_details_ob_grp_v wdd2
2144: WHERE wdd2.delivery_detail_id = wdd.delivery_detail_id

Line 2158: wsh_delivery_assignments_v wda,

2154: EXIT WHEN specified_ship_set%NOTFOUND;
2155: SELECT count(*)
2156: INTO unshipped_count
2157: FROM wsh_delivery_details_ob_grp_v wdd,
2158: wsh_delivery_assignments_v wda,
2159: wsh_new_deliveries_ob_grp_v wnd
2160: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
2161: AND wda.delivery_id = wnd.delivery_id
2162: AND wnd.delivery_id = p_delivery_id

Line 2200: wsh_delivery_assignments_v wda

2196: into exist_unspecified
2197: from dual
2198: where exists (select 1
2199: from wsh_delivery_details_ob_grp_v wdd,
2200: wsh_delivery_assignments_v wda
2201: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
2202: AND wdd.shipped_quantity is null
2203: AND wdd.container_flag = 'N'
2204: AND wda.delivery_id = p_delivery_id

Line 2223: wsh_delivery_assignments_v wda,

2219:
2220: CURSOR delivery_details IS
2221: select wdd.delivery_detail_id
2222: from wsh_delivery_details_ob_grp_v wdd,
2223: wsh_delivery_assignments_v wda,
2224: wsh_new_deliveries_ob_grp_v wnd
2225: where wdd.delivery_detail_id = wda.delivery_detail_id
2226: AND wda.delivery_id = wnd.delivery_id
2227: AND wnd.delivery_id = p_delivery_id

Line 2255: wsh_delivery_assignments_v wda

2251: INTO exist_unqualified
2252: FROM dual
2253: WHERE EXISTS (SELECT 1
2254: FROM wsh_delivery_details_ob_grp_v wdd,
2255: wsh_delivery_assignments_v wda
2256: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
2257: AND wda.delivery_id = p_delivery_id
2258: AND wdd.container_flag = 'N'
2259: AND (wdd.released_status NOT IN ( 'X', 'Y' )