DBA Data[Home] [Help]

APPS.WMS_CONSOLIDATION_PUB dependencies on WMS_DISPATCHED_TASKS_HISTORY

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

2462: SELECT 1
2463: INTO l_count
2464: FROM
2465: wms_license_plate_numbers wlpn,
2466: -- wms_dispatched_tasks_history wdth, Commented by Bug#4337112.
2467: wsh_delivery_details wdd2,
2468: wsh_delivery_assignments_v wda
2469: WHERE wda.delivery_id = p_delivery_id
2470: AND wda.parent_delivery_detail_id = wdd2.delivery_detail_id

Line 2707: wms_dispatched_tasks_history wdth,

2703: l_op_plan_id,
2704: l_from_sub,
2705: l_from_loc
2706: FROM
2707: wms_dispatched_tasks_history wdth,
2708: wms_license_plate_numbers wlpn
2709: WHERE wlpn.organization_id = p_org_id
2710: AND wlpn.outermost_lpn_id = p_lpn_id
2711: AND wdth.organization_id = p_org_id

Line 2730: Wms_Dispatched_Tasks_History Wdth,

2726: l_op_plan_id,
2727: l_from_sub,
2728: l_from_loc
2729: From Mtl_Material_Transactions Mmt,
2730: Wms_Dispatched_Tasks_History Wdth,
2731: Wsh_Delivery_Details_Ob_Grp_v Wdd,
2732: Wsh_Delivery_Assignments Wda,
2733: Wsh_Delivery_Details_Ob_Grp_v Wddc,
2734: Wms_License_Plate_Numbers Wlpn