APPS.WMS_WAVE_PLANNING_PVT dependencies on WMS_WAVEPLAN_TASKS_TEMP

Line 9345: from wms_waveplan_tasks_temp;

9341: status_id,
9342: task_type,
9343: task_type_id,
9344: source_header
9345: from wms_waveplan_tasks_temp;
9346:
9347: cursor c_mmtt is
9348: select distinct transaction_temp_id from wms_waveplan_tasks_temp;
9349:

Line 9348: select distinct transaction_temp_id from wms_waveplan_tasks_temp;

9344: source_header
9345: from wms_waveplan_tasks_temp;
9346:
9347: cursor c_mmtt is
9348: select distinct transaction_temp_id from wms_waveplan_tasks_temp;
9349:
9350: rec_saved_queries c_saved_queries%rowtype;
9351:
9352: l_field_name_table wms_wave_planning_pvt.field_name_table_type;

Line 9378: FROM wms_waveplan_tasks_temp wwtt,

9374: --p_batch_id number;
9375:
9376: CURSOR c_carton_grouping_id IS
9377: SELECT DISTINCT carton_grouping_id
9378: FROM wms_waveplan_tasks_temp wwtt,
9379: mtl_txn_request_lines mtrl,
9380: wsh_Delivery_details wdd
9381: WHERE wwtt.move_order_line_id = mtrl.line_id
9382: and wdd.source_line_id = wwtt.transaction_source_line_id

Line 9434: FROM wms_waveplan_tasks_temp wwtt, mtl_txn_request_lines mtrl

9430: );
9431:
9432: CURSOR c_rc_tasks is
9433: SELECT wwtt.transaction_temp_id
9434: FROM wms_waveplan_tasks_temp wwtt, mtl_txn_request_lines mtrl
9435: WHERE wwtt.move_order_line_id = mtrl.line_id
9436: and wwtt.transaction_temp_id in
9437: (select transaction_temp_id
9438: from wms_wp_tp_mmtt

Line 9446: FROM wms_waveplan_tasks_temp wwtt;

9442: -- Minimum Equipment Capacity
9443:
9444: CURSOR c_task_type is
9445: SELECT DISTINCT wwtt.user_task_type
9446: FROM wms_waveplan_tasks_temp wwtt;
9447: /*
9448: p_user_task_type varchar2(4);
9449:
9450: CURSOR c_tasktype_mmtt(p_user_task_type) is

Line 9452: FROM wms_waveplan_tasks_temp wwtt

9448: p_user_task_type varchar2(4);
9449:
9450: CURSOR c_tasktype_mmtt(p_user_task_type) is
9451: SELECT wwtt.transaction_temp_id transaction_temp_id
9452: FROM wms_waveplan_tasks_temp wwtt
9453: WHERE user_task_type=p_user_task_type;
9454:
9455: */
9456: -- Reverse Trip Stop

Line 9464: FROM wms_waveplan_tasks_temp wwtt,

9460: j number;
9461:
9462: CURSOR c_get_trip is
9463: SELECT distinct wts.trip_id trip_id
9464: FROM wms_waveplan_tasks_temp wwtt,
9465: wsh_Delivery_details wdd,
9466: WSH_NEW_DELIVERIES WND,
9467: WSH_DELIVERY_ASSIGNMENTS WDA,
9468: WSH_TRIP_STOPS WTS,

Line 9544: from wms_waveplan_tasks_temp wwtt, mtl_item_locations_kfv mil

9540: -- Consolidation Locator
9541:
9542: CURSOR c_consol_locator IS
9543: select distinct wwtt.to_locator_id, wwtt.to_locator
9544: from wms_waveplan_tasks_temp wwtt, mtl_item_locations_kfv mil
9545: where wwtt.to_locator_id = mil.inventory_location_id
9546: and wwtt.to_organization_id = mil.organization_id
9547: and mil.inventory_location_type in (4, 5)
9548: and wwtt.transaction_temp_id in

Line 9599: FROM wms_waveplan_tasks_temp wwtt,

9595: l_wdd_staged_count number;
9596:
9597: CURSOR c_delivery_mmtt IS
9598: SELECT DISTINCT WND.DELIVERY_ID delivery_id
9599: FROM wms_waveplan_tasks_temp wwtt,
9600: wsh_Delivery_details wdd,
9601: WSH_NEW_DELIVERIES WND,
9602: WSH_DELIVERY_ASSIGNMENTS WDA
9603: WHERE wdd.source_line_id = wwtt.transaction_source_line_id

Line 9619: FROM wms_waveplan_tasks_temp wwtt,

9615:
9616: -- We get all the tasks for the delivery.
9617: CURSOR c_get_mmtt_delivery(p_delivery_mmtt_id in number) is
9618: SELECT distinct wwtt.transaction_temp_id transaction_temp_id
9619: FROM wms_waveplan_tasks_temp wwtt,
9620: wsh_Delivery_details wdd,
9621: WSH_NEW_DELIVERIES WND,
9622: WSH_DELIVERY_ASSIGNMENTS WDA
9623: WHERE WND.DELIVERY_ID = p_delivery_mmtt_id

Line 9888: delete from wms_waveplan_tasks_temp;

9884: l_cartonization_required := 'N';
9885:
9886: end if;
9887:
9888: delete from wms_waveplan_tasks_temp;
9889:
9890: wms_waveplan_tasks_pvt.query_tasks(p_add => NULL,
9891: p_organization_id => l_organization_id,
9892: p_subinventory_code => l_subinventory,

Line 10079: from wms_waveplan_tasks_temp

10075: -- Need to find out all the tasks for that User task type
10076: g_mmtt_table.delete; --11870443 change to global g_mmtt_table 11870443
10077: select transaction_temp_id bulk collect
10078: into g_mmtt_table --11870443 change to global g_mmtt_table 11870443
10079: from wms_waveplan_tasks_temp
10080: where user_Task_type = l_user_task_type.user_task_type;
10081:
10082: print_debug('Calling Minimum Equipment Capacity API to get the minimum equipment
10083: Capacity ',

Line 10088: from wms_waveplan_tasks_temp

10084: l_debug);
10085:
10086: select sum(transaction_quantity)
10087: into l_sum_qty
10088: from wms_waveplan_tasks_temp
10089: where user_Task_type = l_user_task_type.user_task_type;
10090:
10091: print_debug('Sum of Transaction Qty for User task type ' ||
10092: l_user_task_type.user_task_type || ' is ' ||

Line 14788: TYPE task_type_id IS TABLE OF wms_waveplan_tasks_temp.task_type_id%TYPE INDEX BY BINARY_INTEGER;

14784: TYPE effective_start_date IS TABLE OF wms_dispatched_tasks.effective_start_date%TYPE INDEX BY BINARY_INTEGER;
14785:
14786: TYPE effective_end_date IS TABLE OF wms_dispatched_tasks.effective_end_date%TYPE INDEX BY BINARY_INTEGER;
14787:
14788: TYPE task_type_id IS TABLE OF wms_waveplan_tasks_temp.task_type_id%TYPE INDEX BY BINARY_INTEGER;
14789:
14790: TYPE user_task_type_id IS TABLE OF wms_waveplan_tasks_temp.user_task_type_id%TYPE -- R12: Update User Task Type Id
14791: INDEX BY BINARY_INTEGER;
14792:

Line 14790: TYPE user_task_type_id IS TABLE OF wms_waveplan_tasks_temp.user_task_type_id%TYPE -- R12: Update User Task Type Id

14786: TYPE effective_end_date IS TABLE OF wms_dispatched_tasks.effective_end_date%TYPE INDEX BY BINARY_INTEGER;
14787:
14788: TYPE task_type_id IS TABLE OF wms_waveplan_tasks_temp.task_type_id%TYPE INDEX BY BINARY_INTEGER;
14789:
14790: TYPE user_task_type_id IS TABLE OF wms_waveplan_tasks_temp.user_task_type_id%TYPE -- R12: Update User Task Type Id
14791: INDEX BY BINARY_INTEGER;
14792:
14793: l_transaction_temp_id_table transaction_temp_id_table_type;
14794: l_wms_task_status_table wms_task_status_table_type;