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.WMS_DIRECT_SHIP_PVT dependencies on WSH_DELIVERY_DETAILS_OB_GRP_V

Line 1052: from wsh_delivery_details_ob_grp_v wdd

1048: wdd.inventory_item_id,
1049: wdd.requested_quantity,
1050: msik.concatenated_segments,
1051: msik.description
1052: from wsh_delivery_details_ob_grp_v wdd
1053: ,wsh_delivery_assignments_v wda
1054: ,wsh_new_deliveries_ob_grp_v wnd
1055: ,mtl_system_items_kfv msik
1056: where wnd.delivery_id = p_delivery_id

Line 2915: FROM wsh_delivery_details_ob_grp_v wdd

2911: , wdd.serial_number
2912: , wdd.source_line_id
2913: , wdd.requested_quantity
2914: , wdd.transaction_temp_id
2915: FROM wsh_delivery_details_ob_grp_v wdd
2916: WHERE wdd.organization_id = p_org_id
2917: AND wdd.container_flag <> 'Y'
2918: AND wdd.delivery_detail_id = p_delivery_detail_id
2919: ORDER BY wdd.source_line_id;

Line 2995: FROM wsh_delivery_details_ob_grp_v wdd,

2991: BEGIN
2992: SELECT wdd.delivery_detail_id, wfc.freight_cost_id
2993: INTO l_freight_costs.delivery_detail_id,
2994: l_freight_costs.freight_cost_id
2995: FROM wsh_delivery_details_ob_grp_v wdd,
2996: wsh_freight_costs wfc
2997: WHERE wdd.lpn_id = p_outermost_lpn_id
2998: AND wdd.released_status = 'X' -- For LPN reuse ER : 6845650
2999: AND wdd.delivery_detail_id = wfc.delivery_detail_id;

Line 3084: FROM wsh_delivery_details_ob_grp_v wdd

3080:
3081: --Get the delivery detail id corresponding to the outermost lpn_id
3082: SELECT wdd.delivery_detail_id
3083: INTO l_outermost_dd_id
3084: FROM wsh_delivery_details_ob_grp_v wdd
3085: WHERE lpn_id = p_outermost_lpn_id
3086: AND released_status = 'X'; -- For LPN reuse ER : 6845650
3087:
3088: counter := 0;

Line 3613: FROM wsh_delivery_details_ob_grp_v wdd

3609: FOR UPDATE OF freight_cost_id;
3610:
3611: CURSOR delivery_detail IS
3612: SELECT wdd.delivery_detail_id
3613: FROM wsh_delivery_details_ob_grp_v wdd
3614: WHERE lpn_id = p_lpn_id
3615: AND released_status = 'X'; -- For LPN reuse ER : 6845650
3616:
3617: l_freight_cost_rec wsh_freight_costs_pub.pubfreightcostrectype;

Line 3842: FROM wsh_delivery_details_ob_grp_v dd

3838: , msnt.cycles_since_visit
3839: , msnt.time_since_mark
3840: , msnt.cycles_since_mark
3841: , msnt.number_of_repairs
3842: FROM wsh_delivery_details_ob_grp_v dd
3843: , mtl_serial_numbers_temp msnt
3844: WHERE delivery_detail_id = p_delivery_detail_id
3845: AND msnt.transaction_temp_id = p_transaction_temp_id;
3846:

Line 3960: FROM wsh_delivery_details_ob_grp_v wdd1

3956: END IF;
3957:
3958: SELECT SUM(wdd2.requested_quantity)
3959: INTO l_tot_line_qty
3960: FROM wsh_delivery_details_ob_grp_v wdd1
3961: , wsh_delivery_details_ob_grp_v wdd2
3962: WHERE wdd1.delivery_detail_id = p_delivery_detail_id
3963: AND wdd2.source_header_id = wdd1.source_header_id
3964: AND wdd2.source_line_id = wdd1.source_line_id

Line 3961: , wsh_delivery_details_ob_grp_v wdd2

3957:
3958: SELECT SUM(wdd2.requested_quantity)
3959: INTO l_tot_line_qty
3960: FROM wsh_delivery_details_ob_grp_v wdd1
3961: , wsh_delivery_details_ob_grp_v wdd2
3962: WHERE wdd1.delivery_detail_id = p_delivery_detail_id
3963: AND wdd2.source_header_id = wdd1.source_header_id
3964: AND wdd2.source_line_id = wdd1.source_line_id
3965: AND wdd2.source_code = wdd1.source_code

Line 4383: FROM oe_order_lines_all oel, wsh_delivery_details_ob_grp_v wdd

4379: IF (g_cross_unit_allowed = 'N') THEN
4380: -- get the end item unit number
4381: SELECT oel.end_item_unit_number
4382: INTO l_end_item_unit_number
4383: FROM oe_order_lines_all oel, wsh_delivery_details_ob_grp_v wdd
4384: WHERE wdd.delivery_detail_id = p_delivery_detail_id
4385: AND wdd.source_header_id = oel.header_id
4386: AND wdd.source_line_id = oel.line_id;
4387:

Line 4986: FROM wsh_delivery_details_ob_grp_v wdd

4982: AND direct_ship_flag = 'Y';
4983:
4984: CURSOR stage_delivery_detail(p_organization_id NUMBER, p_lpn_id NUMBER) IS
4985: SELECT wdd.delivery_detail_id
4986: FROM wsh_delivery_details_ob_grp_v wdd
4987: , wms_direct_ship_temp wds
4988: WHERE wds.organization_id = p_organization_id
4989: AND wds.lpn_id = p_lpn_id
4990: AND wdd.source_header_id = wds.order_header_id

Line 4998: FROM wsh_delivery_details_ob_grp_v wdd

4994:
4995: /* Bug:2463967 */
4996: CURSOR delete_details(p_outermost_lpn_id NUMBER) IS
4997: SELECT delivery_detail_id
4998: FROM wsh_delivery_details_ob_grp_v wdd
4999: , wms_license_plate_numbers lpn
5000: WHERE lpn.outermost_lpn_id = p_outermost_lpn_id
5001: AND lpn.lpn_id = wdd.lpn_id
5002: AND wdd.released_status = 'X'; -- For LPN reuse ER : 6845650

Line 5143: FROM wsh_delivery_details_ob_grp_v

5139: END IF;
5140:
5141: SELECT delivery_detail_id
5142: INTO l_cont_instance_id
5143: FROM wsh_delivery_details_ob_grp_v
5144: WHERE lpn_id = l_outer_lpn.lpn_id
5145: AND released_status = 'X'; -- For LPN reuse ER : 6845650
5146:
5147: SELECT wdd.delivery_detail_id

Line 5149: FROM wsh_delivery_details_ob_grp_v wdd, wms_direct_ship_temp wds

5145: AND released_status = 'X'; -- For LPN reuse ER : 6845650
5146:
5147: SELECT wdd.delivery_detail_id
5148: INTO l_delivery_detail_id
5149: FROM wsh_delivery_details_ob_grp_v wdd, wms_direct_ship_temp wds
5150: WHERE wds.organization_id = p_organization_id
5151: AND wds.lpn_id = l_outer_lpn.lpn_id
5152: AND wdd.source_header_id = wds.order_header_id
5153: AND wdd.source_line_id = wds.order_line_id

Line 5336: ' wsh_delivery_details_ob_grp_v wdd, ' ||

5332: END IF;
5333:
5334: l_sql_query := l_sql_query ||
5335: ' FROM wms_direct_ship_temp wds, ' ||
5336: ' wsh_delivery_details_ob_grp_v wdd, ' ||
5337: ' mtl_system_items msi ' ||
5338: ' WHERE wds.organization_id = :p_organization_id ' ||
5339: ' AND wds.lpn_id = :p_lpn_id ' ||
5340: ' AND wds.order_header_id = :p_order_header_id ' ||

Line 6970: FROM wsh_delivery_details_ob_grp_v wdd

6966: SELECT wdd.released_status
6967: , wdd.delivery_detail_id
6968: INTO l_status_code
6969: , l_delivery_detail_id
6970: FROM wsh_delivery_details_ob_grp_v wdd
6971: WHERE wdd.container_name = l_lpn_cur.license_plate_number
6972: AND wdd.released_status = 'X'; --Bug#6878521 Made change bt need to chk this
6973:
6974: IF l_status_code = 'C' THEN

Line 7155: FROM wms_shipping_transaction_temp wstt, wsh_delivery_details_ob_grp_v wdd

7151: SELECT wdd.inventory_item_id
7152: , wdd.revision
7153: , wdd.lot_number
7154: , SUM(wdd.picked_quantity)
7155: FROM wms_shipping_transaction_temp wstt, wsh_delivery_details_ob_grp_v wdd
7156: WHERE wstt.delivery_id = p_delivery_id
7157: AND wdd.delivery_detail_id = wstt.delivery_detail_id
7158: AND wdd.released_status = 'Y'
7159: GROUP BY wdd.inventory_item_id, wdd.revision, wdd.lot_number

Line 7213: FROM wms_shipping_transaction_temp wstt, wsh_delivery_details_ob_grp_v wdd

7209: --Query to get the total no. of distinct items in the delivery
7210:
7211: SELECT COUNT(COUNT(*))
7212: INTO l_delivery_item_count
7213: FROM wms_shipping_transaction_temp wstt, wsh_delivery_details_ob_grp_v wdd
7214: WHERE wstt.delivery_id = p_delivery_id
7215: AND wdd.delivery_detail_id = wstt.delivery_detail_id
7216: AND wdd.released_status = 'Y'
7217: GROUP BY wdd.inventory_item_id, wdd.revision;

Line 7263: FROM wms_shipping_transaction_temp wstt, wsh_delivery_details_ob_grp_v wdd

7259: SELECT wdd.delivery_detail_id
7260: , wdd.picked_quantity
7261: INTO l_delivery_detail_id
7262: , l_picked_qty
7263: FROM wms_shipping_transaction_temp wstt, wsh_delivery_details_ob_grp_v wdd
7264: WHERE wstt.delivery_id = p_delivery_id
7265: AND wstt.inventory_item_id = l_item_id
7266: AND wdd.delivery_detail_id = wstt.delivery_detail_id
7267: AND wdd.inventory_item_id = wstt.inventory_item_id

Line 7372: FROM wsh_delivery_details_ob_grp_v

7368: AND parent_lpn_id = l_parent_lpn_id;
7369:
7370: CURSOR container_details(p_organization_id NUMBER, l_lpn_id NUMBER) IS
7371: SELECT delivery_detail_id
7372: FROM wsh_delivery_details_ob_grp_v
7373: WHERE organization_id = p_organization_id
7374: AND lpn_id = l_lpn_id
7375: AND released_status = 'X'; -- For LPN reuse ER : 6845650
7376:

Line 7823: FROM wsh_delivery_details_ob_grp_v

7819: EXIT WHEN lpn_cur%NOTFOUND;
7820:
7821: SELECT delivery_detail_id
7822: INTO l_par_del_det_id
7823: FROM wsh_delivery_details_ob_grp_v
7824: WHERE lpn_id = l_lpn_cur.parent_lpn_id
7825: AND released_status = 'X'; -- For LPN reuse ER : 6845650
7826:
7827: SELECT COUNT(*)

Line 7829: FROM wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd

7825: AND released_status = 'X'; -- For LPN reuse ER : 6845650
7826:
7827: SELECT COUNT(*)
7828: INTO l_count_del_assign
7829: FROM wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd
7830: WHERE wda.parent_delivery_detail_id = l_par_del_det_id
7831: AND wda.delivery_detail_id = wdd.delivery_detail_id
7832: AND NVL(wdd.container_flag, 'N') = 'N';
7833:

Line 7908: FROM wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda, mtl_system_items_kfv msik

7904: x_return_status := fnd_api.g_ret_sts_success;
7905:
7906: SELECT COUNT(*)
7907: INTO l_count
7908: FROM wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda, mtl_system_items_kfv msik
7909: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
7910: AND NVL(wdd.container_flag, 'N') = 'N'
7911: AND wda.delivery_id = p_delivery_id
7912: AND wdd.inventory_item_id = msik.inventory_item_id

Line 7952: FROM wsh_delivery_details_ob_grp_v

7948: l_parent_del_detail_ids parent_del_detail_ids;
7949:
7950: CURSOR parent_del_detail IS
7951: SELECT delivery_detail_id
7952: FROM wsh_delivery_details_ob_grp_v
7953: WHERE lpn_id IN(SELECT parent_lpn_id
7954: FROM wms_shipping_transaction_temp
7955: WHERE delivery_id = p_delivery_id
7956: AND direct_ship_flag = 'Y');

Line 7963: FROM wsh_delivery_details_ob_grp_v

7959: SELECT parent_delivery_detail_id
7960: FROM wsh_delivery_assignments_v
7961: WHERE delivery_id = p_delivery_id
7962: AND delivery_detail_id NOT IN(SELECT delivery_detail_id
7963: FROM wsh_delivery_details_ob_grp_v
7964: WHERE lpn_id IN(SELECT parent_lpn_id
7965: FROM wms_shipping_transaction_temp
7966: WHERE delivery_id = p_delivery_id
7967: AND direct_ship_flag = 'Y'));

Line 8004: FROM wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd

8000: INTO l_num
8001: FROM DUAL
8002: WHERE EXISTS(
8003: SELECT 1
8004: FROM wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd
8005: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
8006: AND wda.delivery_id = p_delivery_id
8007: AND wdd.released_status = 'Y'
8008: AND NVL(container_flag, 'N') = 'N'

Line 8799: FROM wsh_delivery_details_ob_grp_v

8795: SELECT 1
8796: INTO l_order_line_status
8797: FROM DUAL
8798: WHERE EXISTS(SELECT delivery_detail_id
8799: FROM wsh_delivery_details_ob_grp_v
8800: WHERE released_status IN('R', 'B')
8801: AND source_line_id = l_order_line_rec.line_id
8802: UNION ALL -- bug 4232713 - Need to consider staged WDD lines for overpicking scenarios
8803: SELECT wdd.delivery_detail_id

Line 8804: FROM wsh_delivery_details_ob_grp_v wdd, wms_direct_ship_temp wds

8800: WHERE released_status IN('R', 'B')
8801: AND source_line_id = l_order_line_rec.line_id
8802: UNION ALL -- bug 4232713 - Need to consider staged WDD lines for overpicking scenarios
8803: SELECT wdd.delivery_detail_id
8804: FROM wsh_delivery_details_ob_grp_v wdd, wms_direct_ship_temp wds
8805: WHERE wdd.released_status = 'Y'
8806: AND wdd.source_line_id = wds.order_line_id);
8807: EXCEPTION
8808: WHEN NO_DATA_FOUND THEN

Line 10269: FROM wsh_delivery_details_ob_grp_v

10265: , intmed_ship_to_location_id
10266: , ship_method_code
10267: , fob_code
10268: , freight_terms_code
10269: FROM wsh_delivery_details_ob_grp_v
10270: WHERE source_header_id = p_header_id
10271: AND source_line_id = p_line_id;
10272:
10273: l_del_detail_rec del_detail%ROWTYPE;

Line 10371: FROM wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd, wms_direct_ship_temp wds

10367: FUNCTION validate_del_for_ds(p_lpn_id IN NUMBER, p_org_id IN NUMBER, p_dock_door_id IN NUMBER, p_header_id IN NUMBER, p_line_id IN NUMBER)
10368: RETURN BOOLEAN IS
10369: CURSOR del_cur IS
10370: SELECT wda.delivery_id
10371: FROM wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd, wms_direct_ship_temp wds
10372: WHERE wds.organization_id = p_org_id
10373: AND wds.dock_door_id = p_dock_door_id
10374: AND wds.lpn_id = p_lpn_id
10375: AND wds.order_header_id = p_header_id

Line 11598: FROM wsh_delivery_details_ob_grp_v

11594: x_return_status := fnd_api.g_ret_sts_success;
11595:
11596: SELECT delivery_detail_id
11597: INTO l_delivery_detail_id
11598: FROM wsh_delivery_details_ob_grp_v
11599: WHERE source_header_id = p_order_header_id
11600: AND source_line_id = p_order_line_id
11601: AND ROWNUM = 1;
11602: