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_WAVEPLAN_TASKS_PVT dependencies on WMS_DISPATCHED_TASKS

Line 508: /*AND not exists (select 1 from wms_dispatched_tasks wdt

504: AND mcce.entry_status_code not in (2,4,5)
505: AND wwtt.status_id in (1,2) --bug 12614348 - Show child task count for Queued tasks too
506: AND wwtt.task_type_id = 3
507: --bug 12614348 - Show child task count for Queued tasks too
508: /*AND not exists (select 1 from wms_dispatched_tasks wdt
509: where wdt.transaction_temp_id = mcce.cycle_count_entry_id
510: and wdt.status in (2,3))*/
511: GROUP BY wwtt.transaction_temp_id;
512:

Line 666: wwtt.loaded_lpn_id = NVL((select transfer_lpn_id from wms_dispatched_tasks_history wdth where wdth.task_id = wwtt.task_id),

662: */
663: UPDATE wms_waveplan_tasks_temp wwtt
664: -- transfer_lpn_id would be null if it is loaded into the same lpn as that of picked.
665: SET wwtt.picked_lpn_id = NVL(wwtt.content_lpn_id,wwtt.from_lpn_id), /*12984304 Changed the order in NVL */
666: wwtt.loaded_lpn_id = NVL((select transfer_lpn_id from wms_dispatched_tasks_history wdth where wdth.task_id = wwtt.task_id),
667: NVL(wwtt.to_lpn_id, NVL(wwtt.content_lpn_id, wwtt.from_lpn_id)))
668: WHERE wwtt.task_type_id IN (1, 4, 5, 6)
669: AND wwtt.status_id = 6;
670:

Line 2247: l_from_generic := l_from_generic || ', wms_dispatched_tasks wdt ';

2243: END IF;
2244:
2245: IF p_is_queued OR p_is_dispatched OR p_is_loaded OR p_is_active
2246: THEN
2247: l_from_generic := l_from_generic || ', wms_dispatched_tasks wdt ';
2248: END IF;
2249: ELSif ( p_is_completed ) THEN --ER13869750
2250: --Patchset J Bulk Picking Enhancement
2251: --Only include mmt if not querying for completed parent tasks

Line 2260: l_from_generic || 'wms_dispatched_tasks_history wdth';

2256: l_from_generic || 'mtl_material_transactions mmt, ';
2257: END IF;
2258:
2259: l_from_generic :=
2260: l_from_generic || 'wms_dispatched_tasks_history wdth';
2261: /*IF g_operation_sequence_visible = 'T' AND wms_plan_tasks_pvt.g_query_planned_tasks = TRUE THEN
2262: l_from_generic :=
2263: l_from_generic || 'wms_op_opertn_instances_hist wooih';
2264: END IF; */

Line 2267: l_from_generic := l_from_generic || 'wms_dispatched_tasks_history wdth';

2263: l_from_generic || 'wms_op_opertn_instances_hist wooih';
2264: END IF; */
2265: --ER13869750 Starts
2266: ELSIF ( p_is_picknone )THEN
2267: l_from_generic := l_from_generic || 'wms_dispatched_tasks_history wdth';
2268: --ER13869750 Ends
2269: END IF;
2270:
2271: IF p_populate_merged_tasks

Line 2490: || 'AND NOT EXISTS (SELECT 1 FROM wms_dispatched_tasks ';

2486: IF p_is_pending
2487: THEN
2488: l_where_generic :=
2489: l_where_generic
2490: || 'AND NOT EXISTS (SELECT 1 FROM wms_dispatched_tasks ';
2491: l_where_generic :=
2492: l_where_generic
2493: || ' WHERE transaction_temp_id = mmtt.transaction_temp_id) ';
2494: END IF;

Line 8328: l_from_cc := l_from_cc || ', wms_dispatched_tasks wdt ';

8324: IF l_join_wdt
8325: THEN
8326: IF i = 1
8327: THEN
8328: l_from_cc := l_from_cc || ', wms_dispatched_tasks wdt ';
8329: ELSIF i = 2
8330: THEN
8331: l_from_cc :=
8332: l_from_cc || ', wms_dispatched_tasks_history wdt ';

Line 8332: l_from_cc || ', wms_dispatched_tasks_history wdt ';

8328: l_from_cc := l_from_cc || ', wms_dispatched_tasks wdt ';
8329: ELSIF i = 2
8330: THEN
8331: l_from_cc :=
8332: l_from_cc || ', wms_dispatched_tasks_history wdt ';
8333: END IF;
8334: END IF;
8335:
8336: IF p_item_category_id IS NOT NULL OR p_category_set_id IS NOT NULL

Line 8423: || 'AND NOT EXISTS (SELECT 1 FROM wms_dispatched_tasks ';

8419: IF p_is_pending
8420: THEN
8421: l_where_cc :=
8422: l_where_cc
8423: || 'AND NOT EXISTS (SELECT 1 FROM wms_dispatched_tasks ';
8424: l_where_cc :=
8425: l_where_cc
8426: || ' WHERE transaction_temp_id = mcce.cycle_count_entry_id) ';
8427: END IF;

Line 11088: FROM wms_waveplan_tasks_temp wwtt, mtl_material_transactions_temp mmtt, WMS_DISPATCHED_TASKS wdt

11084:
11085: --BUG: 4707588
11086: SELECT wwtt.transaction_temp_id, wwtt.task_type_id, wwtt.status
11087: BULK COLLECT INTO l_transaction_temp_ids, l_task_type_ids, l_statuses
11088: FROM wms_waveplan_tasks_temp wwtt, mtl_material_transactions_temp mmtt, WMS_DISPATCHED_TASKS wdt
11089: WHERE wwtt.transaction_temp_id = wdt.transaction_temp_id AND
11090: wwtt.transaction_temp_id = mmtt.transaction_temp_id AND
11091: wwtt.RESULT = 'X' AND
11092: wwtt.status_id = 3 AND

Line 11093: EXISTS ( SELECT 1 FROM WMS_DISPATCHED_TASKS wdt2

11089: WHERE wwtt.transaction_temp_id = wdt.transaction_temp_id AND
11090: wwtt.transaction_temp_id = mmtt.transaction_temp_id AND
11091: wwtt.RESULT = 'X' AND
11092: wwtt.status_id = 3 AND
11093: EXISTS ( SELECT 1 FROM WMS_DISPATCHED_TASKS wdt2
11094: WHERE wdt2.person_id = wwtt.person_id AND
11095: wdt2.status = 9 AND
11096: wdt2.task_method IS NOT NULL AND
11097: wdt2.transaction_temp_id IN( SELECT transaction_temp_id FROM mtl_material_transactions_temp mmtt1

Line 11134: EXISTS ( SELECT 1 FROM MTL_MOBILE_LOGIN_HIST MMLH, WMS_DISPATCHED_TASKS WDT

11130: BULK COLLECT INTO l_transaction_temp_ids, l_task_type_ids, l_statuses
11131: FROM wms_waveplan_tasks_temp wwtt
11132: WHERE RESULT = 'X' AND
11133: status_id = 9 AND
11134: EXISTS ( SELECT 1 FROM MTL_MOBILE_LOGIN_HIST MMLH, WMS_DISPATCHED_TASKS WDT
11135: WHERE WDT.TRANSACTION_TEMP_ID = WWTT.TRANSACTION_TEMP_ID AND
11136: MMLH.USER_ID = WDT.LAST_UPDATED_BY AND
11137: MMLH.LOGOFF_DATE IS NULL AND
11138: MMLH.EVENT_MESSAGE IS NULL

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

11308: -- If changing status to Queued
11309: IF p_to_status_id = 2
11310: THEN
11311: UPDATE wms_waveplan_tasks_temp
11312: SET task_id = NVL (task_id, wms_dispatched_tasks_s.NEXTVAL),
11313: status = p_to_status,
11314: status_id = p_to_status_id,
11315: priority =
11316: DECODE (p_clear_priority,

Line 11571: TYPE person_id_table_type IS TABLE OF wms_dispatched_tasks.person_id%TYPE

11567:
11568: TYPE task_priority_table_type IS TABLE OF mtl_material_transactions_temp.task_priority%TYPE
11569: INDEX BY BINARY_INTEGER;
11570:
11571: TYPE person_id_table_type IS TABLE OF wms_dispatched_tasks.person_id%TYPE
11572: INDEX BY BINARY_INTEGER;
11573:
11574: TYPE person_resource_id_table_type IS TABLE OF wms_dispatched_tasks.person_resource_id%TYPE /* Bug 5630187 */
11575: INDEX BY BINARY_INTEGER;

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

11570:
11571: TYPE person_id_table_type IS TABLE OF wms_dispatched_tasks.person_id%TYPE
11572: INDEX BY BINARY_INTEGER;
11573:
11574: TYPE person_resource_id_table_type IS TABLE OF wms_dispatched_tasks.person_resource_id%TYPE /* Bug 5630187 */
11575: INDEX BY BINARY_INTEGER;
11576:
11577: TYPE effective_start_date IS TABLE OF wms_dispatched_tasks.effective_start_date%TYPE
11578: INDEX BY BINARY_INTEGER;

Line 11577: TYPE effective_start_date IS TABLE OF wms_dispatched_tasks.effective_start_date%TYPE

11573:
11574: TYPE person_resource_id_table_type IS TABLE OF wms_dispatched_tasks.person_resource_id%TYPE /* Bug 5630187 */
11575: INDEX BY BINARY_INTEGER;
11576:
11577: TYPE effective_start_date IS TABLE OF wms_dispatched_tasks.effective_start_date%TYPE
11578: INDEX BY BINARY_INTEGER;
11579:
11580: TYPE effective_end_date IS TABLE OF wms_dispatched_tasks.effective_end_date%TYPE
11581: INDEX BY BINARY_INTEGER;

Line 11580: TYPE effective_end_date IS TABLE OF wms_dispatched_tasks.effective_end_date%TYPE

11576:
11577: TYPE effective_start_date IS TABLE OF wms_dispatched_tasks.effective_start_date%TYPE
11578: INDEX BY BINARY_INTEGER;
11579:
11580: TYPE effective_end_date IS TABLE OF wms_dispatched_tasks.effective_end_date%TYPE
11581: INDEX BY BINARY_INTEGER;
11582:
11583: TYPE task_type_id IS TABLE OF wms_waveplan_tasks_temp.task_type_id%TYPE
11584: INDEX BY BINARY_INTEGER;

Line 11674: wms_dispatched_tasks wdt

11670: THEN
11671: SELECT mmtt.transaction_temp_id
11672: INTO l_transaction_temp_id_table (i)
11673: FROM mtl_material_transactions_temp mmtt,
11674: wms_dispatched_tasks wdt
11675: WHERE mmtt.transaction_temp_id =
11676: rec_wwtt.transaction_temp_id
11677: AND mmtt.transaction_temp_id = wdt.transaction_temp_id(+)
11678: AND mmtt.wms_task_type = wdt.task_type(+)

Line 11708: wms_dispatched_tasks wdt

11704: ELSE
11705: SELECT mcce.cycle_count_entry_id
11706: INTO l_transaction_temp_id_table (i)
11707: FROM mtl_cycle_count_entries mcce,
11708: wms_dispatched_tasks wdt
11709: WHERE mcce.cycle_count_entry_id =
11710: rec_wwtt.transaction_temp_id
11711: AND mcce.cycle_count_entry_id = wdt.transaction_temp_id(+)
11712: AND 3 = wdt.task_type(+)

Line 11848: DELETE wms_dispatched_tasks wdt

11844: end if;
11845: END IF;
11846:
11847: -- Delete WDT line for tasks that were queued but now are pending or unreleased
11848: DELETE wms_dispatched_tasks wdt
11849: WHERE wdt.status IN (2, 3, 9) -- R12: Delete the Active or Dispatched tasks which were updated to pending/Unreleased
11850: AND wdt.transaction_temp_id IN (
11851: SELECT transaction_temp_id
11852: FROM wms_waveplan_tasks_temp wwtt

Line 11869: INSERT INTO wms_dispatched_tasks

11865: DEBUG ('inserting into WDT ' || x_save_count);
11866: end if;
11867:
11868: -- Insert into WDT tasks that have become queued from pending or unreleased
11869: INSERT INTO wms_dispatched_tasks
11870: (task_id, transaction_temp_id, organization_id,
11871: user_task_type, person_id, effective_start_date,
11872: effective_end_date, person_resource_id,
11873: machine_resource_id, status, dispatched_time,

Line 11898: FROM wms_dispatched_tasks wdt

11894: wwtt.task_type_id <> 3
11895: )
11896: AND NOT EXISTS (
11897: SELECT 1
11898: FROM wms_dispatched_tasks wdt
11899: WHERE wdt.transaction_temp_id =
11900: wwtt.transaction_temp_id));
11901: if l_debug = 1 then
11902: DEBUG ('No of records inserted are-444 ' || SQL%ROWCOUNT);

Line 11906: UPDATE wms_dispatched_tasks wdt

11902: DEBUG ('No of records inserted are-444 ' || SQL%ROWCOUNT);
11903: end if;
11904: -- forall i IN l_transaction_temp_id_table.first..l_transaction_temp_id_table.last
11905: FORALL i IN 1 .. l_transaction_temp_id_table.COUNT
11906: UPDATE wms_dispatched_tasks wdt
11907: SET person_id = l_person_id_table (i),
11908: person_resource_id = l_person_resource_id_table (i),
11909: effective_start_date = l_effective_start_date_table (i),
11910: effective_end_date = l_effective_end_date_table (i),

Line 11938: DELETE wms_dispatched_tasks wdt

11934: BEGIN
11935: DEBUG ('For cycle count child entries.');
11936: -- Delete WDT line for tasks that were queued but now are pending or unreleased
11937: -- Delete the child+parent records
11938: DELETE wms_dispatched_tasks wdt
11939: WHERE wdt.status IN (2, 3)
11940: AND wdt.task_type = 3
11941: AND wdt.transaction_temp_id IN (
11942: SELECT mcce.cycle_count_entry_id

Line 11962: INSERT INTO wms_dispatched_tasks

11958: DEBUG ('inserting into WDT ' || x_save_count);
11959:
11960: -- Insert into WDT tasks that have become queued from pending or unreleased
11961: -- Insert parent+child records
11962: INSERT INTO wms_dispatched_tasks
11963: (task_id, transaction_temp_id, organization_id,
11964: user_task_type, person_id, effective_start_date,
11965: effective_end_date, person_resource_id,
11966: machine_resource_id, status, dispatched_time,

Line 11970: (SELECT wms_dispatched_tasks_s.NEXTVAL, mcce.cycle_count_entry_id,

11966: machine_resource_id, status, dispatched_time,
11967: last_update_date, last_updated_by, creation_date,
11968: created_by, last_update_login, task_type, priority,
11969: move_order_line_id, operation_plan_id, transfer_lpn_id)
11970: (SELECT wms_dispatched_tasks_s.NEXTVAL, mcce.cycle_count_entry_id,
11971: wwtt.organization_id, NVL (wwtt.user_task_type_id, 0),
11972: wwtt.person_id, sysdate, sysdate , /*bug#5965353.replaced effective dates by sysdate */
11973: wwtt.person_resource_id, NULL, 2, -- Queued
11974: NULL, l_update_date, p_user_id, l_update_date, p_user_id,

Line 11993: FROM wms_dispatched_tasks wdt

11989: AND wwtt.status_id_original IN (1, 8)
11990: AND wwtt.task_type_id = 3
11991: AND NOT EXISTS (
11992: SELECT 1
11993: FROM wms_dispatched_tasks wdt
11994: WHERE wdt.transaction_temp_id =
11995: wwtt.transaction_temp_id));
11996:
11997: DEBUG ('No of records inserted are-888 ' || SQL%ROWCOUNT);

Line 12002: UPDATE wms_dispatched_tasks

11998:
11999: -- The parent record must already by updated by above code
12000: -- Update the child records
12001: FORALL i IN 1 .. l_transaction_temp_id_table.COUNT
12002: UPDATE wms_dispatched_tasks
12003: SET person_id = l_person_id_table (i),
12004: effective_start_date = l_effective_start_date_table (i),
12005: effective_end_date = l_effective_end_date_table (i),
12006: priority = l_task_priority_table (i),

Line 13031: l_from_generic := l_from_generic || 'wms_dispatched_tasks_history wdth';

13027: l_select_generic := l_select_generic || 'to_number(null) ';
13028: debug('select for bulk picknone'||l_select_generic);
13029: l_from_generic := null;
13030: l_from_generic := ' FROM ';
13031: l_from_generic := l_from_generic || 'wms_dispatched_tasks_history wdth';
13032: l_from_generic := l_from_generic || ', mtl_system_items_vl msiv '; --Bug 11798973 Modified to fetch translated value
13033: l_from_generic := l_from_generic || ', mtl_item_locations_kfv milv ';
13034: IF p_item_category_id IS NOT NULL OR p_category_set_id IS NOT NULL THEN
13035: l_from_generic := l_from_generic || ', mtl_item_categories mic ';