APPS.WMS_CONSOLIDATION_PUB dependencies on WMS_DISPATCHED_TASKS

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

2603:
2604: SELECT mmtt.transaction_temp_id
2605: INTO l_temp_id
2606: FROM
2607: wms_dispatched_tasks wdt,
2608: mtl_material_transactions_temp mmtt
2609: WHERE mmtt.organization_id = p_org_id
2610: AND mmtt.transfer_lpn_id = p_lpn_id
2611: AND mmtt.transaction_temp_id = wdt.transaction_temp_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

Line 2811: INSERT INTO WMS_DISPATCHED_TASKS

2807: p_lpn_id)
2808: returning transaction_temp_id INTO p_temp_id;
2809:
2810:
2811: INSERT INTO WMS_DISPATCHED_TASKS
2812: (TASK_ID ,
2813: TRANSACTION_TEMP_ID ,
2814: ORGANIZATION_ID ,
2815: USER_TASK_TYPE ,

Line 2834: VALUES(wms_dispatched_tasks_s.nextval,

2830: suggested_dest_subinventory,
2831: suggested_dest_locator_id,
2832: operation_plan_id,
2833: TRANSFER_LPN_ID)
2834: VALUES(wms_dispatched_tasks_s.nextval,
2835: p_temp_id,
2836: p_org_id,
2837: 2,
2838: p_emp_id,