DBA Data[Home] [Help]

APPS.WMS_DEVICE_INTEGRATION_PVT dependencies on WSH_DELIVERY_DETAILS

Line 66: FROM wsh_delivery_details wdd1, wsh_delivery_assignments_v wda,

62: l_rev,
63: l_uom,
64: l_lpn_id,
65: l_qty
66: FROM wsh_delivery_details wdd1, wsh_delivery_assignments_v wda,
67: wsh_delivery_details wdd2
68: WHERE wdd1.DELIVERY_DETAIL_ID = p_task_trx_id
69: AND wdd1.delivery_detail_id = wda.parent_delivery_detail_id
70: AND wda.parent_delivery_detail_id = wdd2.delivery_detail_id;

Line 67: wsh_delivery_details wdd2

63: l_uom,
64: l_lpn_id,
65: l_qty
66: FROM wsh_delivery_details wdd1, wsh_delivery_assignments_v wda,
67: wsh_delivery_details wdd2
68: WHERE wdd1.DELIVERY_DETAIL_ID = p_task_trx_id
69: AND wdd1.delivery_detail_id = wda.parent_delivery_detail_id
70: AND wda.parent_delivery_detail_id = wdd2.delivery_detail_id;
71:

Line 1117: wsh_delivery_details wdd,

1113:
1114: IF v_xml.bus_event_id = wms_be_pick_release THEN
1115: begin
1116: select To_number(wdd.source_header_number) into l_order_num from
1117: wsh_delivery_details wdd,
1118: mtl_material_transactions_temp mmtt
1119: where mmtt.transaction_temp_id = v_xml.taskid
1120: and mmtt.trx_source_line_id = wdd.source_line_id;
1121: EXCEPTION