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_DETAILS_OB_GRP_V

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 220: from wsh_delivery_details_ob_grp_v wdd

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
222: and wdd.organization_id = p_organization_id
223: )
224: )

Line 254: FROM wsh_delivery_details_ob_grp_v wdd,

250: p_inventory_item_id IN NUMBER) IS
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

Line 351: FROM wsh_new_deliveries_ob_grp_v del, wsh_delivery_details_ob_grp_v dd,

347: REQUESTED_QUANTITY_UOM2,
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 )

Line 376: wsh_delivery_details_ob_grp_v dd,

372: --Adding picked_quantity as part of the return cursor.
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

Line 406: wsh_delivery_details_ob_grp_v dd,

402: all_items VARCHAR2(20000) := NULL;
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

Line 481: from wsh_delivery_details_ob_grp_v

477: x_return_Status := 'C';
478: select inventory_item_id, subinventory, revision, locator_id,lot_number, transaction_temp_id, serial_number,picked_quantity
479: into l_inventory_item_id, l_subinventory_code, l_revision, l_locator_id, l_lot_number,
480: l_transaction_temp_id, l_serial_number,l_picked_quantity
481: from wsh_delivery_details_ob_grp_v
482: where delivery_detail_id = p_delivery_detail_id;
483:
484: IF ( l_serial_number IS NULL ) THEN
485: IF ( l_transaction_temp_id IS NULL ) THEN

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 665: , wsh_delivery_details_ob_grp_v wdd

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;
668:
669: BEGIN

Line 686: from wsh_delivery_details_ob_grp_v dd

682: END IF;
683:
684: select dd.requested_quantity, dd.picked_quantity,dd.requested_quantity2
685: INTO l_requested_quantity, l_picked_quantity, l_requested_quantity2
686: from wsh_delivery_details_ob_grp_v dd
687: where
688: dd.delivery_detail_id = l_delivery_details_id_table(l_table_index);
689:
690: l_backorder_quantities_table(l_table_index) :=

Line 719: from wsh_delivery_details_ob_grp_v

715: -- change the LPN context first since we changed the LPN context to
716: -- picked after pick confirm
717: select lpn_id
718: into l_lpn_id
719: from wsh_delivery_details_ob_grp_v
720: where delivery_detail_id = l_parent_delivery_detail_id;
721:
722: IF (l_debug = 1) THEN
723: debug('Change the context of LPNs to 1:'||l_lpn_id,'wshtxn');

Line 906: from wsh_delivery_details_ob_grp_v dd

902: p_relieve_rsv IN VARCHAR2 DEFAULT 'Y')
903: IS
904: cursor delivery_line(p_delivery_detail_id NUMBER) is
905: select dd.delivery_detail_id, dd.requested_quantity, dd.picked_quantity
906: from wsh_delivery_details_ob_grp_v dd
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

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 1046: FROM wsh_delivery_details_ob_grp_v wdd

1042: END IF;
1043:
1044: SELECT lpn_id
1045: INTO l_lpn_id
1046: FROM wsh_delivery_details_ob_grp_v wdd
1047: WHERE delivery_detail_id = l_parent_delivery_detail_id;
1048:
1049: IF l_debug = 1 THEN
1050: debug('l_lpn_id: '|| l_lpn_id, 'INV_LINE_RETURN_TO_STOCK');

Line 1225: from wsh_delivery_details_ob_grp_v dd

1221: /* Change the cursor to pick up secondary picked and requested quantities */
1222: cursor delivery_line(p_delivery_detail_id NUMBER) is
1223: select dd.delivery_detail_id, dd.requested_quantity, dd.picked_quantity,
1224: PICKED_QUANTITY2, REQUESTED_QUANTITY2
1225: from wsh_delivery_details_ob_grp_v dd
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

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 1333: FROM wsh_delivery_details_ob_grp_v wdd

1329: EXIT WHEN lpn_csr%NOTFOUND;
1330:
1331: SELECT lpn_id
1332: INTO l_lpn_id
1333: FROM wsh_delivery_details_ob_grp_v wdd
1334: WHERE delivery_detail_id = l_parent_delivery_detail_id;
1335:
1336: --update LPN(s) context to Resides in Inventory
1337: FOR l_par_lpn_id IN nested_parent_lpn_cursor(l_lpn_id) LOOP

Line 1600: FROM WSH_DELIVERY_DETAILS_OB_GRP_V

1596: CURSOR c_weight_vol_info IS
1597: SELECT unit_weight,
1598: unit_volume,
1599: nvl(wv_frozen_flag ,'N') wv_frozen_flag
1600: FROM WSH_DELIVERY_DETAILS_OB_GRP_V
1601: WHERE delivery_detail_id = p_delivery_line_id;
1602:
1603: l_weight_vol_info c_weight_vol_info%ROWTYPE;
1604:

Line 1725: FROM WSH_DELIVERY_DETAILS_OB_GRP_V

1721: CURSOR c_weight_vol_info IS
1722: SELECT unit_weight,
1723: unit_volume,
1724: nvl(wv_frozen_flag ,'N') wv_frozen_flag
1725: FROM WSH_DELIVERY_DETAILS_OB_GRP_V
1726: WHERE delivery_detail_id = p_delivery_line_id;
1727:
1728: l_weight_vol_info c_weight_vol_info%ROWTYPE;
1729:

Line 1965: FROM wsh_delivery_details_ob_grp_v

1961: BEGIN
1962:
1963: SELECT source_line_id
1964: INTO l_source_line_id
1965: FROM wsh_delivery_details_ob_grp_v
1966: WHERE delivery_detail_id = p_delivery_detail_id;
1967:
1968: RETURN GET_LINE_TRANSACTION_TYPE(l_source_line_id,x_trx_source_type_id,
1969: x_trx_action_id,x_return_status);

Line 1988: from wsh_delivery_details_ob_grp_v dd,

1984: IS
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

Line 2139: FROM wsh_delivery_details_ob_grp_v wdd,

2135: unshipped_count NUMBER;
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

Line 2143: FROM wsh_delivery_details_ob_grp_v wdd2

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
2145: AND wdd2.ship_set_id is not null
2146: AND wdd2.shipped_quantity is not null)
2147: AND wda.delivery_id = p_delivery_id;

Line 2157: FROM wsh_delivery_details_ob_grp_v wdd,

2153: FETCH specified_ship_set INTO l_ship_set_id;
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

Line 2199: from wsh_delivery_details_ob_grp_v wdd,

2195: select 1
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'

Line 2222: from wsh_delivery_details_ob_grp_v wdd,

2218: l_return_status VARCHAR2(1);
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

Line 2254: FROM wsh_delivery_details_ob_grp_v wdd,

2250: SELECT 1
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'

Line 2775: From wsh_delivery_details_ob_grp_v

2771: l_return_status := 'S';
2772:
2773: select transaction_temp_id
2774: into l_transaction_temp_id
2775: From wsh_delivery_details_ob_grp_v
2776: where delivery_detail_id = l_delivery_detail_id;
2777:
2778: l_delay_quantity := l_requested_quantity - l_shipped_quantity;
2779:

Line 2792: from wsh_delivery_details_ob_grp_v

2788: end if;
2789:
2790: select transaction_temp_id
2791: into l_new_transaction_temp_id
2792: from wsh_delivery_details_ob_grp_v
2793: where delivery_detail_id = l_new_delivery_line_id;
2794:
2795: IF (l_debug = 1) THEN
2796: debug('new transaction_temp_id is ' || l_new_transaction_temp_id,

Line 2920: From wsh_delivery_details_ob_grp_v

2916: l_return_status := 'S';
2917:
2918: select transaction_temp_id
2919: into l_transaction_temp_id
2920: From wsh_delivery_details_ob_grp_v
2921: where delivery_detail_id = l_delivery_detail_id;
2922:
2923: l_delay_quantity := l_requested_quantity - l_shipped_quantity;
2924:

Line 2960: from wsh_delivery_details_ob_grp_v

2956: end if;
2957:
2958: select transaction_temp_id
2959: into l_new_transaction_temp_id
2960: from wsh_delivery_details_ob_grp_v
2961: where delivery_detail_id = l_new_delivery_line_id;
2962:
2963: IF (l_debug = 1) THEN
2964: debug('new transaction_temp_id is ' || l_new_transaction_temp_id,

Line 3044: from mtl_serial_numbers_temp msnt, wsh_delivery_details_ob_grp_v wdd

3040: l_count NUMBER;
3041: BEGIN
3042: select count(*)
3043: into l_count
3044: from mtl_serial_numbers_temp msnt, wsh_delivery_details_ob_grp_v wdd
3045: where msnt.transaction_temp_id = wdd.transaction_temp_id
3046: and wdd.delivery_detail_id = l_delivery_detail_id
3047: and wdd.transaction_temp_id = l_transaction_temp_id;
3048:

Line 3052: From wsh_delivery_details_ob_grp_v

3048:
3049: if( l_count > 0 ) then
3050: delete from mtl_serial_numbers_temp
3051: where transaction_temp_id in (select transaction_temp_id
3052: From wsh_delivery_details_ob_grp_v
3053: where transaction_temp_id = l_transaction_temp_id
3054: And delivery_detail_id = l_delivery_detail_id);
3055: end if;
3056: x_return_status := FND_API.G_RET_STS_SUCCESS;