eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_WAVE_PLANNING_PVT dependencies on WMS_DISPATCHED_TASKS

Line 7111: wms_dispatched_tasks wdt

7107: select sum(mmtt.transaction_quantity), Count(*), br.resource_type
7108: into l_transaction_quantity, l_number_of_tasks, l_resource_type
7109: from bom_resources br,
7110: mtl_material_transactions_temp mmtt,
7111: wms_dispatched_tasks wdt
7112: where mmtt.subinventory_code =
7113: l_resource_details.source_subinventory
7114: and mmtt.transfer_subinventory =
7115: l_resource_details.destination_subinventory

Line 7142: wms_dispatched_tasks wdt,

7138: select sum(mmtt.transaction_quantity), Count(*), br.resource_type
7139: into l_transaction_quantity, l_number_of_tasks, l_resource_type
7140: from bom_resources br,
7141: mtl_material_transactions_temp mmtt,
7142: wms_dispatched_tasks wdt,
7143: wms_zone_locators wzl1,
7144: wms_zone_locators wzl2,
7145: wms_zones_vl wz1,
7146: wms_zones_vl wz2

Line 14429: WMS_DISPATCHED_TASKS wdt

14425: SELECT wwtt.transaction_temp_id, wwtt.task_type_id, wwtt.status BULK COLLECT
14426: INTO l_transaction_temp_ids, l_task_type_ids, l_statuses
14427: FROM wms_wp_tasks_gtmp wwtt,
14428: mtl_material_transactions_temp mmtt,
14429: WMS_DISPATCHED_TASKS wdt
14430: WHERE wwtt.transaction_temp_id = wdt.transaction_temp_id
14431: AND wwtt.transaction_temp_id = mmtt.transaction_temp_id
14432: AND wwtt.RESULT = 'X'
14433: AND wwtt.status_id = 3

Line 14436: FROM WMS_DISPATCHED_TASKS wdt2

14432: AND wwtt.RESULT = 'X'
14433: AND wwtt.status_id = 3
14434: AND EXISTS
14435: (SELECT 1
14436: FROM WMS_DISPATCHED_TASKS wdt2
14437: WHERE wdt2.person_id = wwtt.person_id
14438: AND wdt2.status = 9
14439: AND wdt2.task_method IS NOT NULL
14440: AND wdt2.transaction_temp_id IN

Line 14485: FROM MTL_MOBILE_LOGIN_HIST MMLH, WMS_DISPATCHED_TASKS WDT

14481: WHERE RESULT = 'X'
14482: AND status_id = 9
14483: AND EXISTS
14484: (SELECT 1
14485: FROM MTL_MOBILE_LOGIN_HIST MMLH, WMS_DISPATCHED_TASKS WDT
14486: WHERE WDT.TRANSACTION_TEMP_ID = WWTT.TRANSACTION_TEMP_ID
14487: AND MMLH.USER_ID = WDT.LAST_UPDATED_BY
14488: AND MMLH.LOGOFF_DATE IS NULL
14489: AND MMLH.EVENT_MESSAGE IS NULL);

Line 14638: SET task_id = NVL(task_id, wms_dispatched_tasks_s.NEXTVAL),

14634:
14635: -- If changing status to Queued
14636: IF p_to_status_id = 2 THEN
14637: UPDATE wms_wp_tasks_gtmp
14638: SET task_id = NVL(task_id, wms_dispatched_tasks_s.NEXTVAL),
14639: status = p_to_status,
14640: status_id = p_to_status_id,
14641: priority = DECODE(p_clear_priority,
14642: 'Y',

Line 14779: TYPE person_id_table_type IS TABLE OF wms_dispatched_tasks.person_id%TYPE INDEX BY BINARY_INTEGER;

14775: TYPE wms_task_status_table_type IS TABLE OF mtl_material_transactions_temp.wms_task_status%TYPE INDEX BY BINARY_INTEGER;
14776:
14777: TYPE task_priority_table_type IS TABLE OF mtl_material_transactions_temp.task_priority%TYPE INDEX BY BINARY_INTEGER;
14778:
14779: TYPE person_id_table_type IS TABLE OF wms_dispatched_tasks.person_id%TYPE INDEX BY BINARY_INTEGER;
14780:
14781: TYPE person_resource_id_table_type IS TABLE OF wms_dispatched_tasks.person_resource_id%TYPE /* Bug 5630187 */
14782: INDEX BY BINARY_INTEGER;
14783:

Line 14781: TYPE person_resource_id_table_type IS TABLE OF wms_dispatched_tasks.person_resource_id%TYPE /* Bug 5630187 */

14777: TYPE task_priority_table_type IS TABLE OF mtl_material_transactions_temp.task_priority%TYPE INDEX BY BINARY_INTEGER;
14778:
14779: TYPE person_id_table_type IS TABLE OF wms_dispatched_tasks.person_id%TYPE INDEX BY BINARY_INTEGER;
14780:
14781: TYPE person_resource_id_table_type IS TABLE OF wms_dispatched_tasks.person_resource_id%TYPE /* Bug 5630187 */
14782: INDEX BY BINARY_INTEGER;
14783:
14784: TYPE effective_start_date IS TABLE OF wms_dispatched_tasks.effective_start_date%TYPE INDEX BY BINARY_INTEGER;
14785:

Line 14784: TYPE effective_start_date IS TABLE OF wms_dispatched_tasks.effective_start_date%TYPE INDEX BY BINARY_INTEGER;

14780:
14781: TYPE person_resource_id_table_type IS TABLE OF wms_dispatched_tasks.person_resource_id%TYPE /* Bug 5630187 */
14782: INDEX BY BINARY_INTEGER;
14783:
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;

Line 14786: TYPE effective_end_date IS TABLE OF wms_dispatched_tasks.effective_end_date%TYPE INDEX BY BINARY_INTEGER;

14782: INDEX BY BINARY_INTEGER;
14783:
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

Line 14892: wms_dispatched_tasks wdt

14888: IF rec_wwtt.task_type_id <> 3 THEN
14889: SELECT mmtt.transaction_temp_id
14890: INTO l_transaction_temp_id_table(i)
14891: FROM mtl_material_transactions_temp mmtt,
14892: wms_dispatched_tasks wdt
14893: WHERE mmtt.transaction_temp_id = rec_wwtt.transaction_temp_id
14894: AND mmtt.transaction_temp_id = wdt.transaction_temp_id(+)
14895: AND mmtt.wms_task_type = wdt.task_type(+)
14896: AND DECODE(wdt.status,

Line 14993: DELETE wms_dispatched_tasks wdt

14989: end if;
14990: END IF;
14991:
14992: -- Delete WDT line for tasks that were queued but now are pending or unreleased
14993: DELETE wms_dispatched_tasks wdt
14994: WHERE wdt.status IN (2, 3, 9) -- R12: Delete the Active or Dispatched tasks which were updated to pending/Unreleased
14995: AND wdt.transaction_temp_id IN
14996: (SELECT transaction_temp_id
14997: FROM wms_wp_tasks_gtmp wwtt

Line 15011: INSERT INTO wms_dispatched_tasks

15007: print_DEBUG('inserting into WDT ' || x_save_count, l_debug);
15008: end if;
15009:
15010: -- Insert into WDT tasks that have become queued from pending or unreleased
15011: INSERT INTO wms_dispatched_tasks
15012: (task_id,
15013: transaction_temp_id,
15014: organization_id,
15015: user_task_type,

Line 15060: FROM wms_dispatched_tasks wdt

15056: AND wwtt.status_id_original IN (1, 8)
15057: AND wwtt.is_modified = 'Y'
15058: AND NOT EXISTS
15059: (SELECT 1
15060: FROM wms_dispatched_tasks wdt
15061: WHERE wdt.transaction_temp_id = wwtt.transaction_temp_id));
15062: if l_debug = 1 then
15063: print_DEBUG('No of records inserted are-444 ' || SQL%ROWCOUNT,
15064: l_debug);

Line 15068: UPDATE wms_dispatched_tasks

15064: l_debug);
15065: end if;
15066: -- forall i IN l_transaction_temp_id_table.first..l_transaction_temp_id_table.last
15067: FORALL i IN 1 .. l_transaction_temp_id_table.COUNT
15068: UPDATE wms_dispatched_tasks
15069: SET person_id = l_person_id_table(i),
15070: person_resource_id = l_person_resource_id_table(i),
15071: effective_start_date = l_effective_start_date_table(i),
15072: effective_end_date = l_effective_end_date_table(i),

Line 15446: FROM wsh_delivery_details wdd, mtl_material_transactions_temp mmtt, wms_dispatched_tasks wdt

15442: --also modified to join with wdt
15443: SELECT Sum(Decode(Nvl(wdt.status,0), 4, 1, 0)) loaded,
15444: Count(1) total_tasked
15445: into v_loaded, v_total
15446: FROM wsh_delivery_details wdd, mtl_material_transactions_temp mmtt, wms_dispatched_tasks wdt
15447: WHERE wdd.delivery_detail_id = p_Delivery_Detail_id
15448: AND wdd.move_order_line_id = mmtt.move_order_line_id
15449: AND wdt.transaction_temp_id (+) = mmtt.TRANSACTION_temp_id;
15450:

Line 18388: wms_dispatched_tasks wdt,

18384: wms_op_plans_vl wopv,
18385: per_all_people_f pap,
18386: wms_op_operation_instances wooi,
18387: WMS_WP_WAVE_LINES WWL,
18388: wms_dispatched_tasks wdt,
18389: bom_standard_operations bso,
18390: bom_resources br1
18391: where mmtt.transaction_temp_id = wdt.transaction_temp_id(+)
18392: AND wdt.person_id = pap.person_id(+)

Line 18520: wms_dispatched_tasks wdt,

18516: wms_op_plans_vl wopv,
18517: per_all_people_f pap,
18518: wms_op_operation_instances wooi,
18519: WMS_WP_WAVE_LINES WWL,
18520: wms_dispatched_tasks wdt,
18521: bom_standard_operations bso,
18522: bom_resources br1
18523: where mmtt.transaction_temp_id = wdt.transaction_temp_id(+)
18524: AND wdt.person_id = pap.person_id(+)

Line 18668: wms_dispatched_tasks wdt,

18664: wms_op_plans_vl wopv,
18665: per_all_people_f pap,
18666: wms_op_operation_instances wooi,
18667: WMS_WP_WAVE_LINES WWL,
18668: wms_dispatched_tasks wdt,
18669: bom_standard_operations bso,
18670: bom_resources br1,
18671: mtl_txn_request_headers mtrh,
18672: mtl_txn_request_lines mtrl,

Line 18832: wms_dispatched_tasks_history wdth,

18828: wms_op_plans_vl wopv,
18829: per_all_people_f pap,
18830: wms_op_operation_instances wooi,
18831: WMS_WP_WAVE_LINES WWL,
18832: wms_dispatched_tasks_history wdth,
18833: bom_standard_operations bso,
18834: bom_resources br1
18835: where mmt.transaction_set_id = wdth.transaction_id
18836: AND decode(mmt.transfer_transaction_id, null, 0, mmt.transaction_quantity) <= 0

Line 19006: wms_dispatched_tasks wdt,

19002: wms_op_plans_vl wopv,
19003: per_all_people_f pap,
19004: wms_op_operation_instances wooi,
19005: WMS_WP_WAVE_LINES WWL,
19006: wms_dispatched_tasks wdt,
19007: bom_standard_operations bso,
19008: bom_resources br1,
19009: mtl_txn_request_lines mtrl
19010: where mmtt.transaction_temp_id = wdt.transaction_temp_id(+)

Line 19165: wms_dispatched_tasks_history wdth,

19161: wms_op_plans_vl wopv,
19162: per_all_people_f pap,
19163: wms_op_operation_instances wooi,
19164: WMS_WP_WAVE_LINES WWL,
19165: wms_dispatched_tasks_history wdth,
19166: bom_standard_operations bso,
19167: bom_resources br1,
19168: mtl_txn_request_lines mtrl,
19169: mtl_txn_request_headers mtrh