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

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

Line 253: FROM wsh_delivery_details_ob_grp_v wdd,

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

Line 350: FROM wsh_new_deliveries_ob_grp_v del, wsh_delivery_details_ob_grp_v dd,

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

Line 375: wsh_delivery_details_ob_grp_v dd,

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

Line 405: wsh_delivery_details_ob_grp_v dd,

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

Line 480: from wsh_delivery_details_ob_grp_v

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

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

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

Line 685: from wsh_delivery_details_ob_grp_v dd

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

Line 718: from wsh_delivery_details_ob_grp_v

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

Line 905: from wsh_delivery_details_ob_grp_v dd

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

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

1023: END IF;
1024:
1025: SELECT lpn_id
1026: INTO l_lpn_id
1027: FROM wsh_delivery_details_ob_grp_v wdd
1028: WHERE delivery_detail_id = l_parent_delivery_detail_id;
1029:
1030: IF l_debug = 1 THEN
1031: debug('l_lpn_id: '|| l_lpn_id, 'INV_LINE_RETURN_TO_STOCK');

Line 1206: from wsh_delivery_details_ob_grp_v dd

1202: /* Change the cursor to pick up secondary picked and requested quantities */
1203: cursor delivery_line(p_delivery_detail_id NUMBER) is
1204: select dd.delivery_detail_id, dd.requested_quantity, dd.picked_quantity,
1205: PICKED_QUANTITY2, REQUESTED_QUANTITY2
1206: from wsh_delivery_details_ob_grp_v dd
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

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

1310: EXIT WHEN lpn_csr%NOTFOUND;
1311:
1312: SELECT lpn_id
1313: INTO l_lpn_id
1314: FROM wsh_delivery_details_ob_grp_v wdd
1315: WHERE delivery_detail_id = l_parent_delivery_detail_id;
1316:
1317: --update LPN(s) context to Resides in Inventory
1318: FOR l_par_lpn_id IN nested_parent_lpn_cursor(l_lpn_id) LOOP

Line 1581: FROM WSH_DELIVERY_DETAILS_OB_GRP_V

1577: CURSOR c_weight_vol_info IS
1578: SELECT unit_weight,
1579: unit_volume,
1580: nvl(wv_frozen_flag ,'N') wv_frozen_flag
1581: FROM WSH_DELIVERY_DETAILS_OB_GRP_V
1582: WHERE delivery_detail_id = p_delivery_line_id;
1583:
1584: l_weight_vol_info c_weight_vol_info%ROWTYPE;
1585:

Line 1706: FROM WSH_DELIVERY_DETAILS_OB_GRP_V

1702: CURSOR c_weight_vol_info IS
1703: SELECT unit_weight,
1704: unit_volume,
1705: nvl(wv_frozen_flag ,'N') wv_frozen_flag
1706: FROM WSH_DELIVERY_DETAILS_OB_GRP_V
1707: WHERE delivery_detail_id = p_delivery_line_id;
1708:
1709: l_weight_vol_info c_weight_vol_info%ROWTYPE;
1710:

Line 1946: FROM wsh_delivery_details_ob_grp_v

1942: BEGIN
1943:
1944: SELECT source_line_id
1945: INTO l_source_line_id
1946: FROM wsh_delivery_details_ob_grp_v
1947: WHERE delivery_detail_id = p_delivery_detail_id;
1948:
1949: RETURN GET_LINE_TRANSACTION_TYPE(l_source_line_id,x_trx_source_type_id,
1950: x_trx_action_id,x_return_status);

Line 1969: from wsh_delivery_details_ob_grp_v dd,

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

Line 2095: FROM wsh_delivery_details_ob_grp_v wdd,

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

Line 2099: FROM wsh_delivery_details_ob_grp_v wdd2

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
2101: AND wdd2.ship_set_id is not null
2102: AND wdd2.shipped_quantity is not null)
2103: AND wda.delivery_id = p_delivery_id;

Line 2113: FROM wsh_delivery_details_ob_grp_v wdd,

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

Line 2155: from wsh_delivery_details_ob_grp_v wdd,

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

Line 2178: from wsh_delivery_details_ob_grp_v wdd,

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

Line 2210: from wsh_delivery_details_ob_grp_v wdd,

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

Line 2621: From wsh_delivery_details_ob_grp_v

2617: l_return_status := 'S';
2618:
2619: select transaction_temp_id
2620: into l_transaction_temp_id
2621: From wsh_delivery_details_ob_grp_v
2622: where delivery_detail_id = l_delivery_detail_id;
2623:
2624: l_delay_quantity := l_requested_quantity - l_shipped_quantity;
2625:

Line 2638: from wsh_delivery_details_ob_grp_v

2634: end if;
2635:
2636: select transaction_temp_id
2637: into l_new_transaction_temp_id
2638: from wsh_delivery_details_ob_grp_v
2639: where delivery_detail_id = l_new_delivery_line_id;
2640:
2641: IF (l_debug = 1) THEN
2642: debug('new transaction_temp_id is ' || l_new_transaction_temp_id,

Line 2765: From wsh_delivery_details_ob_grp_v

2761: l_return_status := 'S';
2762:
2763: select transaction_temp_id
2764: into l_transaction_temp_id
2765: From wsh_delivery_details_ob_grp_v
2766: where delivery_detail_id = l_delivery_detail_id;
2767:
2768: l_delay_quantity := l_requested_quantity - l_shipped_quantity;
2769:

Line 2805: from wsh_delivery_details_ob_grp_v

2801: end if;
2802:
2803: select transaction_temp_id
2804: into l_new_transaction_temp_id
2805: from wsh_delivery_details_ob_grp_v
2806: where delivery_detail_id = l_new_delivery_line_id;
2807:
2808: IF (l_debug = 1) THEN
2809: debug('new transaction_temp_id is ' || l_new_transaction_temp_id,

Line 2889: from mtl_serial_numbers_temp msnt, wsh_delivery_details_ob_grp_v wdd

2885: l_count NUMBER;
2886: BEGIN
2887: select count(*)
2888: into l_count
2889: from mtl_serial_numbers_temp msnt, wsh_delivery_details_ob_grp_v wdd
2890: where msnt.transaction_temp_id = wdd.transaction_temp_id
2891: and wdd.delivery_detail_id = l_delivery_detail_id
2892: and wdd.transaction_temp_id = l_transaction_temp_id;
2893:

Line 2897: From wsh_delivery_details_ob_grp_v

2893:
2894: if( l_count > 0 ) then
2895: delete from mtl_serial_numbers_temp
2896: where transaction_temp_id in (select transaction_temp_id
2897: From wsh_delivery_details_ob_grp_v
2898: where transaction_temp_id = l_transaction_temp_id
2899: And delivery_detail_id = l_delivery_detail_id);
2900: end if;
2901: x_return_status := FND_API.G_RET_STS_SUCCESS;