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 1096: wsh_delivery_details wdd,

1092:
1093: IF v_xml.bus_event_id = wms_be_pick_release THEN
1094: begin
1095: select To_number(wdd.source_header_number) into l_order_num from
1096: wsh_delivery_details wdd,
1097: mtl_material_transactions_temp mmtt
1098: where mmtt.transaction_temp_id = v_xml.taskid
1099: and mmtt.trx_source_line_id = wdd.source_line_id;
1100: EXCEPTION