APPS.WMS_CONSOLIDATION_PUB dependencies on WMS_DISPATCHED_TASKS

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 2615: wms_dispatched_tasks wdt,

2611:
2612: SELECT mmtt.transaction_temp_id
2613: INTO l_temp_id
2614: FROM
2615: wms_dispatched_tasks wdt,
2616: mtl_material_transactions_temp mmtt
2617: WHERE mmtt.organization_id = p_org_id
2618: AND mmtt.transfer_lpn_id = p_lpn_id
2619: AND mmtt.transaction_temp_id = wdt.transaction_temp_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

Line 2905: INSERT INTO WMS_DISPATCHED_TASKS

2901: p_lpn_id)
2902: returning transaction_temp_id INTO p_temp_id;
2903:
2904:
2905: INSERT INTO WMS_DISPATCHED_TASKS
2906: (TASK_ID ,
2907: TRANSACTION_TEMP_ID ,
2908: ORGANIZATION_ID ,
2909: USER_TASK_TYPE ,

Line 2928: VALUES(wms_dispatched_tasks_s.nextval,

2924: suggested_dest_subinventory,
2925: suggested_dest_locator_id,
2926: operation_plan_id,
2927: TRANSFER_LPN_ID)
2928: VALUES(wms_dispatched_tasks_s.nextval,
2929: p_temp_id,
2930: p_org_id,
2931: 2,
2932: p_emp_id,