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' or
175: ( wdd.released_status = 'X' and

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

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

Line 216: from wsh_delivery_assignments_v wda

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

Line 235: wsh_delivery_assignments wda

231: FROM wsh_new_deliveries wnd
232: WHERE wnd.delivery_id IN
233: ( SELECT wda.delivery_id
234: FROM wsh_delivery_details wdd,
235: wsh_delivery_assignments wda
236: WHERE wdd.lpn_id = p_lpn_id
237: AND wdd.organization_id = p_organization_id
238: AND wda.parent_delivery_detail_id = wdd.delivery_detail_id
239: AND wdd.released_status = 'X' -- For LPN reuse ER : 6845650

Line 254: wsh_delivery_assignments_v wda,

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

Line 351: wsh_delivery_assignments_v da, mtl_system_items_vl msiv

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

Line 376: wsh_delivery_assignments_v da,

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

Line 406: wsh_delivery_assignments_v da,

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

Line 615: from wsh_delivery_assignments_v da,wsh_delivery_details_ob_grp_v dd

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

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

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

Line 623: , wsh_delivery_assignments_v wda2

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

Line 662: FROM wsh_delivery_assignments_v wda

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

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

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

Line 911: , wsh_delivery_assignments_v wda2

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

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

1207: WHERE dd.delivery_detail_id = p_delivery_detail_id;
1208:
1209: cursor lpn_csr(p_delivery_detail_id in NUMBER) is
1210: select wdd.delivery_detail_id, wda.delivery_assignment_id,wda2.delivery_assignment_id
1211: from wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd2
1212: , wsh_delivery_assignments_v wda2
1213: where wdd.delivery_detail_id = wda.parent_delivery_detail_id
1214: and wda.delivery_detail_id = wdd2.delivery_detail_id
1215: and wdd2.delivery_detail_id = p_delivery_detail_id

Line 1212: , wsh_delivery_assignments_v wda2

1208:
1209: cursor lpn_csr(p_delivery_detail_id in NUMBER) is
1210: select wdd.delivery_detail_id, wda.delivery_assignment_id,wda2.delivery_assignment_id
1211: from wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd2
1212: , wsh_delivery_assignments_v wda2
1213: where wdd.delivery_detail_id = wda.parent_delivery_detail_id
1214: and wda.delivery_detail_id = wdd2.delivery_detail_id
1215: and wdd2.delivery_detail_id = p_delivery_detail_id
1216: and wda2.delivery_detail_id = wdd.delivery_detail_id;

Line 1970: wsh_delivery_assignments_v da

1966:
1967: CURSOR c_delivery_details is
1968: SELECT dd.*
1969: from wsh_delivery_details_ob_grp_v dd,
1970: wsh_delivery_assignments_v da
1971: where
1972: da.delivery_id = p_delivery_id
1973: and da.delivery_detail_id = dd.delivery_detail_id
1974: and dd.lpn_id is null;

Line 2096: wsh_delivery_assignments_v wda

2092:
2093: CURSOR specified_ship_set IS
2094: SELECT wdd.ship_set_id
2095: FROM wsh_delivery_details_ob_grp_v wdd,
2096: wsh_delivery_assignments_v wda
2097: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
2098: AND EXISTS (SELECT 'x'
2099: FROM wsh_delivery_details_ob_grp_v wdd2
2100: WHERE wdd2.delivery_detail_id = wdd.delivery_detail_id

Line 2114: wsh_delivery_assignments_v wda,

2110: EXIT WHEN specified_ship_set%NOTFOUND;
2111: SELECT count(*)
2112: INTO unshipped_count
2113: FROM wsh_delivery_details_ob_grp_v wdd,
2114: wsh_delivery_assignments_v wda,
2115: wsh_new_deliveries_ob_grp_v wnd
2116: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
2117: AND wda.delivery_id = wnd.delivery_id
2118: AND wnd.delivery_id = p_delivery_id

Line 2156: wsh_delivery_assignments_v wda

2152: into exist_unspecified
2153: from dual
2154: where exists (select 1
2155: from wsh_delivery_details_ob_grp_v wdd,
2156: wsh_delivery_assignments_v wda
2157: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
2158: AND wdd.shipped_quantity is null
2159: AND wdd.container_flag = 'N'
2160: AND wda.delivery_id = p_delivery_id

Line 2179: wsh_delivery_assignments_v wda,

2175:
2176: CURSOR delivery_details IS
2177: select wdd.delivery_detail_id
2178: from wsh_delivery_details_ob_grp_v wdd,
2179: wsh_delivery_assignments_v wda,
2180: wsh_new_deliveries_ob_grp_v wnd
2181: where wdd.delivery_detail_id = wda.delivery_detail_id
2182: AND wda.delivery_id = wnd.delivery_id
2183: AND wnd.delivery_id = p_delivery_id

Line 2211: wsh_delivery_assignments_v wda

2207: into exist_unqualified
2208: from dual
2209: where exists (select 1
2210: from wsh_delivery_details_ob_grp_v wdd,
2211: wsh_delivery_assignments_v wda
2212: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
2213: AND wda.delivery_id = p_delivery_id
2214: AND wdd.container_flag='N'
2215: AND ( wdd.released_status not in ('X', 'Y') OR --'X' for nontransactable item