DBA Data[Home] [Help]

APPS.WMS_CONSOLIDATION_PUB dependencies on WMS_DISPATCHED_TASKS_HISTORY

Line 2461: -- wms_dispatched_tasks_history wdth, Commented by Bug#4337112.

2457: SELECT 1
2458: INTO l_count
2459: FROM
2460: wms_license_plate_numbers wlpn,
2461: -- wms_dispatched_tasks_history wdth, Commented by Bug#4337112.
2462: wsh_delivery_details wdd2,
2463: wsh_delivery_assignments_v wda
2464: WHERE wda.delivery_id = p_delivery_id
2465: AND wda.parent_delivery_detail_id = wdd2.delivery_detail_id

Line 2698: wms_dispatched_tasks_history wdth,

2694: l_op_plan_id,
2695: l_from_sub,
2696: l_from_loc
2697: FROM
2698: wms_dispatched_tasks_history wdth,
2699: wms_license_plate_numbers wlpn
2700: WHERE wlpn.organization_id = p_org_id
2701: AND wlpn.outermost_lpn_id = p_lpn_id
2702: AND wdth.organization_id = p_org_id