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

Line 1135: from wsh_delivery_details_ob_grp_v wdd

1131: wdd.inventory_item_id,
1132: wdd.requested_quantity,
1133: msik.concatenated_segments,
1134: msik.description
1135: from wsh_delivery_details_ob_grp_v wdd
1136: ,wsh_delivery_assignments_v wda
1137: ,wsh_new_deliveries_ob_grp_v wnd
1138: ,mtl_system_items_kfv msik
1139: where wnd.delivery_id = p_delivery_id

Line 1213: l_ignore_for_planning wsh_delivery_details.ignore_for_planning%type;

1209:
1210:
1211: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1212:
1213: l_ignore_for_planning wsh_delivery_details.ignore_for_planning%type;
1214: l_tms_interface_flag wsh_new_deliveries.TMS_INTERFACE_FLAG%type;
1215: l_otm_trip_id wsh_trips.trip_id%type;
1216: l_otm_carrier_id wsh_trips.carrier_id%type;
1217: l_otm_ship_method_code wsh_trips.ship_method_code%type;

Line 3071: FROM wsh_delivery_details_ob_grp_v wdd

3067: , wdd.serial_number
3068: , wdd.source_line_id
3069: , wdd.requested_quantity
3070: , wdd.transaction_temp_id
3071: FROM wsh_delivery_details_ob_grp_v wdd
3072: WHERE wdd.organization_id = p_org_id
3073: AND wdd.container_flag <> 'Y'
3074: AND wdd.delivery_detail_id = p_delivery_detail_id
3075: ORDER BY wdd.source_line_id;

Line 3152: FROM wsh_delivery_details_ob_grp_v wdd,

3148: BEGIN
3149: SELECT wdd.delivery_detail_id, wfc.freight_cost_id
3150: INTO l_freight_costs.delivery_detail_id,
3151: l_freight_costs.freight_cost_id
3152: FROM wsh_delivery_details_ob_grp_v wdd,
3153: wsh_freight_costs wfc
3154: WHERE wdd.lpn_id = p_outermost_lpn_id
3155: AND wdd.released_status = 'X' -- For LPN reuse ER : 6845650
3156: AND wdd.delivery_detail_id = wfc.delivery_detail_id;

Line 3241: FROM wsh_delivery_details_ob_grp_v wdd

3237:
3238: --Get the delivery detail id corresponding to the outermost lpn_id
3239: SELECT wdd.delivery_detail_id
3240: INTO l_outermost_dd_id
3241: FROM wsh_delivery_details_ob_grp_v wdd
3242: WHERE lpn_id = p_outermost_lpn_id
3243: AND released_status = 'X'; -- For LPN reuse ER : 6845650
3244:
3245: counter := 0;

Line 3815: FROM wsh_delivery_details_ob_grp_v wdd

3811: FOR UPDATE OF freight_cost_id;
3812:
3813: CURSOR delivery_detail IS
3814: SELECT wdd.delivery_detail_id
3815: FROM wsh_delivery_details_ob_grp_v wdd
3816: WHERE lpn_id = p_lpn_id
3817: AND released_status = 'X'; -- For LPN reuse ER : 6845650
3818:
3819: l_freight_cost_rec wsh_freight_costs_pub.pubfreightcostrectype;

Line 4044: FROM wsh_delivery_details_ob_grp_v dd

4040: , msnt.cycles_since_visit
4041: , msnt.time_since_mark
4042: , msnt.cycles_since_mark
4043: , msnt.number_of_repairs
4044: FROM wsh_delivery_details_ob_grp_v dd
4045: , mtl_serial_numbers_temp msnt
4046: WHERE delivery_detail_id = p_delivery_detail_id
4047: AND msnt.transaction_temp_id = p_transaction_temp_id;
4048:

Line 4162: FROM wsh_delivery_details_ob_grp_v wdd1

4158: END IF;
4159:
4160: SELECT SUM(wdd2.requested_quantity)
4161: INTO l_tot_line_qty
4162: FROM wsh_delivery_details_ob_grp_v wdd1
4163: , wsh_delivery_details_ob_grp_v wdd2
4164: WHERE wdd1.delivery_detail_id = p_delivery_detail_id
4165: AND wdd2.source_header_id = wdd1.source_header_id
4166: AND wdd2.source_line_id = wdd1.source_line_id

Line 4163: , wsh_delivery_details_ob_grp_v wdd2

4159:
4160: SELECT SUM(wdd2.requested_quantity)
4161: INTO l_tot_line_qty
4162: FROM wsh_delivery_details_ob_grp_v wdd1
4163: , wsh_delivery_details_ob_grp_v wdd2
4164: WHERE wdd1.delivery_detail_id = p_delivery_detail_id
4165: AND wdd2.source_header_id = wdd1.source_header_id
4166: AND wdd2.source_line_id = wdd1.source_line_id
4167: AND wdd2.source_code = wdd1.source_code

Line 4585: FROM oe_order_lines_all oel, wsh_delivery_details_ob_grp_v wdd

4581: IF (g_cross_unit_allowed = 'N') THEN
4582: -- get the end item unit number
4583: SELECT oel.end_item_unit_number
4584: INTO l_end_item_unit_number
4585: FROM oe_order_lines_all oel, wsh_delivery_details_ob_grp_v wdd
4586: WHERE wdd.delivery_detail_id = p_delivery_detail_id
4587: AND wdd.source_header_id = oel.header_id
4588: AND wdd.source_line_id = oel.line_id;
4589:

Line 4772: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_ACTIONS.EXPLODE_DELIVERY_DETAILS');

4768: ROLLBACK;
4769: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4770: WHEN OTHERS THEN
4771: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
4772: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_ACTIONS.EXPLODE_DELIVERY_DETAILS');
4773: END explode_delivery_details;
4774:
4775:
4776: /* Function overship_staged_lines

Line 4806: l_shipping_attr WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;

4802: l_msg_data VARCHAR2(3000);
4803: l_msg_count NUMBER;
4804: l_error_code VARCHAR2(20000);
4805: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4806: l_shipping_attr WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;
4807: l_shipping_attr_tab wsh_interface.changedattributetabtype;
4808: l_delivery_detail_id NUMBER;
4809: l_picked_qty NUMBER;
4810: l_sec_picked_qty NUMBER;

Line 4939: wsh_delivery_details_ob_grp_v wdd

4935: , l_sec_picked_qty
4936: , l_shipped_qty
4937: , l_sec_shipped_qty
4938: FROM wms_direct_ship_temp wds,
4939: wsh_delivery_details_ob_grp_v wdd
4940: WHERE wds.organization_id = p_organization_id
4941: AND wds.lpn_id = p_lpn_id
4942: AND wds.order_header_id = p_source_header_id
4943: AND wds.order_line_id = p_source_line_id

Line 5026: WSH_DELIVERY_DETAILS_PUB.split_line

5022: IF (l_debug = 1) THEN
5023: DEBUG('Before Split Line'||l_delivery_Detail_id,'Overship Staged Lines');
5024: END IF;
5025:
5026: WSH_DELIVERY_DETAILS_PUB.split_line
5027: (p_api_version => 1.0,
5028: p_init_msg_list => fnd_api.g_false,
5029: p_commit => fnd_api.g_false,
5030: x_return_status => l_return_status,

Line 5058: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_Cont(

5054: END IF;
5055:
5056: /*Unassign from old container*/
5057:
5058: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_Cont(
5059: P_DETAIL_ID => l_new_delivery_detail_id,
5060: X_RETURN_STATUS => l_return_status);
5061:
5062: IF (l_debug = 1) THEN

Line 5186: WSH_DELIVERY_DETAILS WDD,

5182: ,l_delivery_detail_tab(i).REQUESTED_QUANTITY_UOM2
5183: ,l_delivery_detail_tab(i).LOT_CONTROL_CODE
5184: ,l_delivery_detail_tab(i).SERIAL_NUMBER_CONTROL_CODE
5185: FROM WMS_DIRECT_SHIP_TEMP WDS,
5186: WSH_DELIVERY_DETAILS WDD,
5187: MTL_SYSTEM_ITEMS MSI
5188: WHERE WDS.ORGANIZATION_ID = p_organization_id
5189: AND WDS.lpn_id = p_lpn_id
5190: AND WDS.ORDER_HEADER_ID = p_source_header_id

Line 5264: FROM wsh_delivery_details_ob_grp_v wdd

5260: AND direct_ship_flag = 'Y';
5261:
5262: CURSOR stage_delivery_detail(p_organization_id NUMBER, p_lpn_id NUMBER) IS
5263: SELECT wdd.delivery_detail_id
5264: FROM wsh_delivery_details_ob_grp_v wdd
5265: , wms_direct_ship_temp wds
5266: WHERE wds.organization_id = p_organization_id
5267: AND wds.lpn_id = p_lpn_id
5268: AND wdd.source_header_id = wds.order_header_id

Line 5276: FROM wsh_delivery_details_ob_grp_v wdd

5272:
5273: /* Bug:2463967 */
5274: CURSOR delete_details(p_outermost_lpn_id NUMBER) IS
5275: SELECT delivery_detail_id
5276: FROM wsh_delivery_details_ob_grp_v wdd
5277: , wms_license_plate_numbers lpn
5278: WHERE lpn.outermost_lpn_id = p_outermost_lpn_id
5279: AND lpn.lpn_id = wdd.lpn_id
5280: AND wdd.released_status = 'X'; -- For LPN reuse ER : 6845650

Line 5395: l_ignore_for_planning wsh_delivery_details.ignore_for_planning%type;

5391: /**********************************
5392: * variable to hold the ignore_for_planning flag of WDD.
5393: * Added for g-log changes
5394: **********************************/
5395: l_ignore_for_planning wsh_delivery_details.ignore_for_planning%type;
5396: l_tms_interface_flag wsh_new_deliveries.TMS_INTERFACE_FLAG%type;
5397:
5398: l_dual_uom_item BOOLEAN := FALSE;
5399:

Line 5443: FROM wsh_delivery_details_ob_grp_v

5439: END IF;
5440:
5441: SELECT delivery_detail_id
5442: INTO l_cont_instance_id
5443: FROM wsh_delivery_details_ob_grp_v
5444: WHERE lpn_id = l_outer_lpn.lpn_id
5445: AND released_status = 'X'; -- For LPN reuse ER : 6845650
5446:
5447: SELECT wdd.delivery_detail_id

Line 5449: FROM wsh_delivery_details_ob_grp_v wdd, wms_direct_ship_temp wds

5445: AND released_status = 'X'; -- For LPN reuse ER : 6845650
5446:
5447: SELECT wdd.delivery_detail_id
5448: INTO l_delivery_detail_id
5449: FROM wsh_delivery_details_ob_grp_v wdd, wms_direct_ship_temp wds
5450: WHERE wds.organization_id = p_organization_id
5451: AND wds.lpn_id = l_outer_lpn.lpn_id
5452: AND wdd.source_header_id = wds.order_header_id
5453: AND wdd.source_line_id = wds.order_line_id

Line 5656: ' wsh_delivery_details_ob_grp_v wdd, ' ||

5652: END IF;
5653:
5654: l_sql_query := l_sql_query ||
5655: ' FROM wms_direct_ship_temp wds, ' ||
5656: ' wsh_delivery_details_ob_grp_v wdd, ' ||
5657: ' mtl_system_items msi ' ||
5658: ' WHERE wds.organization_id = :p_organization_id ' ||
5659: ' AND wds.lpn_id = :p_lpn_id ' ||
5660: ' AND wds.order_header_id = :p_order_header_id ' ||

Line 7994: l_container_name wsh_delivery_details.container_name%TYPE;

7990: l_segmentarray fnd_flex_ext.segmentarray;
7991: l_count NUMBER := 0;
7992: l_net_weight NUMBER;
7993: l_deliv_det_id NUMBER;
7994: l_container_name wsh_delivery_details.container_name%TYPE;
7995: l_container_flag wsh_delivery_details.container_flag%TYPE;
7996: l_container_rec wsh_container_grp.changedattributetabtype;
7997: -- added for bug 2529382
7998: l_status_code VARCHAR2(2);

Line 7995: l_container_flag wsh_delivery_details.container_flag%TYPE;

7991: l_count NUMBER := 0;
7992: l_net_weight NUMBER;
7993: l_deliv_det_id NUMBER;
7994: l_container_name wsh_delivery_details.container_name%TYPE;
7995: l_container_flag wsh_delivery_details.container_flag%TYPE;
7996: l_container_rec wsh_container_grp.changedattributetabtype;
7997: -- added for bug 2529382
7998: l_status_code VARCHAR2(2);
7999: l_container_new_name VARCHAR2(30);

Line 8067: FROM wsh_delivery_details_ob_grp_v wdd

8063: SELECT wdd.released_status
8064: , wdd.delivery_detail_id
8065: INTO l_status_code
8066: , l_delivery_detail_id
8067: FROM wsh_delivery_details_ob_grp_v wdd
8068: WHERE wdd.container_name = l_lpn_cur.license_plate_number
8069: AND wdd.released_status = 'X'; --Bug#6878521 Made change bt need to chk this
8070:
8071: IF l_status_code = 'C' THEN

Line 8143: --If the LPN does not exist in in wsh_delivery_details, create a new container

8139: IF (l_debug = 1) THEN
8140: DEBUG('LPN EXISTS: ' || l_count, 'create_update_containers');
8141: END IF;
8142:
8143: --If the LPN does not exist in in wsh_delivery_details, create a new container
8144: IF l_count = 0 THEN
8145:
8146: /* Release 12 (K): LPN Synchronization
8147: Replace the call to wsh_container_grp.create_containers

Line 8252: FROM wms_shipping_transaction_temp wstt, wsh_delivery_details_ob_grp_v wdd

8248: SELECT wdd.inventory_item_id
8249: , wdd.revision
8250: , wdd.lot_number
8251: , SUM(wdd.picked_quantity)
8252: FROM wms_shipping_transaction_temp wstt, wsh_delivery_details_ob_grp_v wdd
8253: WHERE wstt.delivery_id = p_delivery_id
8254: AND wdd.delivery_detail_id = wstt.delivery_detail_id
8255: AND wdd.released_status = 'Y'
8256: GROUP BY wdd.inventory_item_id, wdd.revision, wdd.lot_number

Line 8278: l_shipping_attr wsh_delivery_details_pub.changedattributetabtype;

8274: l_revision VARCHAR2(3);
8275: -- Increased lot size to 80 Char - Mercy Thomas - B4625329
8276: l_lot_number VARCHAR2(80);
8277: l_del_qty NUMBER;
8278: l_shipping_attr wsh_delivery_details_pub.changedattributetabtype;
8279: l_delivery_detail_id NUMBER;
8280: l_picked_qty NUMBER;
8281: l_extra_qty NUMBER;
8282: l_lpn_qty NUMBER;

Line 8310: FROM wms_shipping_transaction_temp wstt, wsh_delivery_details_ob_grp_v wdd

8306: --Query to get the total no. of distinct items in the delivery
8307:
8308: SELECT COUNT(COUNT(*))
8309: INTO l_delivery_item_count
8310: FROM wms_shipping_transaction_temp wstt, wsh_delivery_details_ob_grp_v wdd
8311: WHERE wstt.delivery_id = p_delivery_id
8312: AND wdd.delivery_detail_id = wstt.delivery_detail_id
8313: AND wdd.released_status = 'Y'
8314: GROUP BY wdd.inventory_item_id, wdd.revision;

Line 8360: FROM wms_shipping_transaction_temp wstt, wsh_delivery_details_ob_grp_v wdd

8356: SELECT wdd.delivery_detail_id
8357: , wdd.picked_quantity
8358: INTO l_delivery_detail_id
8359: , l_picked_qty
8360: FROM wms_shipping_transaction_temp wstt, wsh_delivery_details_ob_grp_v wdd
8361: WHERE wstt.delivery_id = p_delivery_id
8362: AND wstt.inventory_item_id = l_item_id
8363: AND wdd.delivery_detail_id = wstt.delivery_detail_id
8364: AND wdd.inventory_item_id = wstt.inventory_item_id

Line 8373: -- Call WSH_DELIVERY_DETAILS to update the shipped_qty

8369: WHEN NO_DATA_FOUND THEN
8370: NULL;
8371: END;
8372:
8373: -- Call WSH_DELIVERY_DETAILS to update the shipped_qty
8374: l_shipping_attr(1).shipped_quantity := l_picked_qty + l_extra_qty;
8375: l_shipping_attr(1).delivery_detail_id := l_delivery_detail_id;
8376: wsh_delivery_details_pub.update_shipping_attributes(
8377: p_api_version_number => 1.0

Line 8376: wsh_delivery_details_pub.update_shipping_attributes(

8372:
8373: -- Call WSH_DELIVERY_DETAILS to update the shipped_qty
8374: l_shipping_attr(1).shipped_quantity := l_picked_qty + l_extra_qty;
8375: l_shipping_attr(1).delivery_detail_id := l_delivery_detail_id;
8376: wsh_delivery_details_pub.update_shipping_attributes(
8377: p_api_version_number => 1.0
8378: , p_source_code => 'OE'
8379: , p_init_msg_list => l_init_msg_list
8380: , p_commit => l_commit

Line 8469: FROM wsh_delivery_details_ob_grp_v

8465: AND parent_lpn_id = l_parent_lpn_id;
8466:
8467: CURSOR container_details(p_organization_id NUMBER, l_lpn_id NUMBER) IS
8468: SELECT delivery_detail_id
8469: FROM wsh_delivery_details_ob_grp_v
8470: WHERE organization_id = p_organization_id
8471: AND lpn_id = l_lpn_id
8472: AND released_status = 'X'; -- For LPN reuse ER : 6845650
8473:

Line 8920: FROM wsh_delivery_details_ob_grp_v

8916: EXIT WHEN lpn_cur%NOTFOUND;
8917:
8918: SELECT delivery_detail_id
8919: INTO l_par_del_det_id
8920: FROM wsh_delivery_details_ob_grp_v
8921: WHERE lpn_id = l_lpn_cur.parent_lpn_id
8922: AND released_status = 'X'; -- For LPN reuse ER : 6845650
8923:
8924: SELECT COUNT(*)

Line 8926: FROM wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd

8922: AND released_status = 'X'; -- For LPN reuse ER : 6845650
8923:
8924: SELECT COUNT(*)
8925: INTO l_count_del_assign
8926: FROM wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd
8927: WHERE wda.parent_delivery_detail_id = l_par_del_det_id
8928: AND wda.delivery_detail_id = wdd.delivery_detail_id
8929: AND NVL(wdd.container_flag, 'N') = 'N';
8930:

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

9001: x_return_status := fnd_api.g_ret_sts_success;
9002:
9003: SELECT COUNT(*)
9004: INTO l_count
9005: FROM wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda, mtl_system_items_kfv msik
9006: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
9007: AND NVL(wdd.container_flag, 'N') = 'N'
9008: AND wda.delivery_id = p_delivery_id
9009: AND wdd.inventory_item_id = msik.inventory_item_id

Line 9048: FROM wsh_delivery_details_ob_grp_v

9044: l_parent_del_detail_ids parent_del_detail_ids;
9045:
9046: CURSOR parent_del_detail IS
9047: SELECT delivery_detail_id
9048: FROM wsh_delivery_details_ob_grp_v
9049: WHERE lpn_id IN(SELECT parent_lpn_id
9050: FROM wms_shipping_transaction_temp
9051: WHERE delivery_id = p_delivery_id
9052: AND direct_ship_flag = 'Y');

Line 9059: FROM wsh_delivery_details_ob_grp_v

9055: SELECT parent_delivery_detail_id
9056: FROM wsh_delivery_assignments_v
9057: WHERE delivery_id = p_delivery_id
9058: AND delivery_detail_id NOT IN(SELECT delivery_detail_id
9059: FROM wsh_delivery_details_ob_grp_v
9060: WHERE lpn_id IN(SELECT parent_lpn_id
9061: FROM wms_shipping_transaction_temp
9062: WHERE delivery_id = p_delivery_id
9063: AND direct_ship_flag = 'Y'));

Line 9098: FROM wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd

9094: INTO l_num
9095: FROM DUAL
9096: WHERE EXISTS(
9097: SELECT 1
9098: FROM wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd
9099: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
9100: AND wda.delivery_id = p_delivery_id
9101: AND wdd.released_status = 'Y'
9102: AND NVL(container_flag, 'N') = 'N'

Line 9227: FROM wsh_delivery_details_ob_grp_v wdd

9223: RAISE fnd_api.g_exc_unexpected_error;
9224: END IF;
9225:
9226: SELECT nvl(wdd.source_line_set_id,wdd.source_line_id) into l_line_set_id
9227: FROM wsh_delivery_details_ob_grp_v wdd
9228: WHERE wdd.source_header_id = p_order_header_id
9229: AND wdd.source_line_id= p_order_line_id
9230: AND rownum<2;
9231:

Line 9241: FROM wsh_delivery_details_ob_grp_v wdd

9237: SELECT NVL(SUM(NVL(picked_quantity,0)),0)
9238: , NVL(SUM(NVL(picked_quantity2,0)),0)
9239: INTO l_staged_qty
9240: , l_staged_sec_qty
9241: FROM wsh_delivery_details_ob_grp_v wdd
9242: WHERE source_header_id = p_order_header_id
9243: AND released_status='Y'
9244: AND nvl(source_line_set_id,source_line_id) = l_line_set_id;
9245:

Line 9260: FROM wsh_delivery_details_ob_grp_v wdd

9256: FROM mtl_reservations
9257: WHERE organization_id= p_org_id
9258: AND nvl(staged_flag,'N') = 'Y'
9259: AND demand_source_line_id in ( SELECT source_line_id
9260: FROM wsh_delivery_details_ob_grp_v wdd
9261: WHERE source_header_id = p_order_header_id
9262: AND released_status='Y'
9263: AND nvl(source_line_set_id,source_line_id) = l_line_set_id );
9264:

Line 9977: --Bug 2909327:Changed the call to check wsh_delivery_details instead of oel*/

9973: DEBUG('l_order_line_rec.flow_status_code: ' ||
9974: l_order_line_rec.flow_status_code, 'Process_LPN');
9975: END IF;
9976:
9977: --Bug 2909327:Changed the call to check wsh_delivery_details instead of oel*/
9978: BEGIN
9979: SELECT 1
9980: INTO l_order_line_status
9981: FROM DUAL

Line 9983: FROM wsh_delivery_details_ob_grp_v

9979: SELECT 1
9980: INTO l_order_line_status
9981: FROM DUAL
9982: WHERE EXISTS(SELECT delivery_detail_id
9983: FROM wsh_delivery_details_ob_grp_v
9984: WHERE released_status IN('R','B')
9985: AND source_line_id = l_order_line_rec.line_id)
9986: -- bug 4232713 - Need to consider staged WDD lines for overpicking scenarios
9987: OR EXISTS(SELECT wdd.delivery_detail_id

Line 9988: FROM wsh_delivery_details_ob_grp_v wdd, wms_direct_ship_temp wds

9984: WHERE released_status IN('R','B')
9985: AND source_line_id = l_order_line_rec.line_id)
9986: -- bug 4232713 - Need to consider staged WDD lines for overpicking scenarios
9987: OR EXISTS(SELECT wdd.delivery_detail_id
9988: FROM wsh_delivery_details_ob_grp_v wdd, wms_direct_ship_temp wds
9989: WHERE wdd.released_status = 'Y'
9990: AND wdd.source_line_id = wds.order_line_id
9991: AND wds.order_line_id = l_order_line_rec.line_id);
9992: EXCEPTION

Line 12016: FROM wsh_delivery_details_ob_grp_v

12012: , intmed_ship_to_location_id
12013: , ship_method_code
12014: , fob_code
12015: , freight_terms_code
12016: FROM wsh_delivery_details_ob_grp_v
12017: WHERE source_header_id = p_header_id
12018: AND source_line_id = p_line_id;
12019:
12020: l_del_detail_rec del_detail%ROWTYPE;

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

12120: ) RETURN BOOLEAN IS
12121:
12122: CURSOR del_cur IS
12123: SELECT wda.delivery_id
12124: FROM wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd, wms_direct_ship_temp wds
12125: WHERE wds.organization_id = p_org_id
12126: AND wds.dock_door_id = p_dock_door_id
12127: AND wds.lpn_id = p_lpn_id
12128: AND wds.order_header_id = p_header_id

Line 12869: FROM wsh_delivery_details_ob_grp_v

12865: SELECT NVL(SUM(picked_quantity),0)
12866: , NVL(SUM(picked_quantity2),0)
12867: INTO l_staged_qty
12868: , l_staged_sec_qty
12869: FROM wsh_delivery_details_ob_grp_v
12870: WHERE source_header_id = l_order_header_id
12871: AND source_line_id = l_order_line_id
12872: AND released_status = 'Y';
12873:

Line 13268: FROM wsh_delivery_details_ob_grp_v

13264: SELECT NVL(SUM(picked_quantity),0)
13265: , NVL(SUM(picked_quantity2),0)
13266: INTO l_staged_qty
13267: , l_staged_sec_qty
13268: FROM wsh_delivery_details_ob_grp_v
13269: WHERE source_header_id = l_order_header_id
13270: AND source_line_id = l_order_line_id
13271: AND released_status = 'Y';
13272:

Line 13587: FROM wsh_delivery_details_ob_grp_v

13583: x_return_status := fnd_api.g_ret_sts_success;
13584:
13585: SELECT delivery_detail_id
13586: INTO l_delivery_detail_id
13587: FROM wsh_delivery_details_ob_grp_v
13588: WHERE source_header_id = p_order_header_id
13589: AND source_line_id = p_order_line_id
13590: AND ROWNUM = 1;
13591: