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 MTL_MATERIAL_TRANSACTIONS_TEMP

Line 584: mtl_material_transactions_temp mmtt

580: --wwtt used to get the parent task.
581: SELECT COUNT (1), wwtt.transaction_temp_id
582: BULK COLLECT INTO l_num_of_child_tasks_tbl, l_parent_temp_ids_tbl
583: FROM wms_waveplan_tasks_temp wwtt,
584: mtl_material_transactions_temp mmtt
585: WHERE wwtt.transaction_temp_id = mmtt.parent_line_id
586: AND wwtt.transaction_temp_id <> mmtt.transaction_temp_id
587: GROUP BY wwtt.transaction_temp_id;
588:

Line 2236: l_from_generic || 'mtl_material_transactions_temp mmtt ';

2232:
2233: IF p_is_unreleased OR p_is_pending OR p_is_queued OR p_is_dispatched OR p_is_active OR p_is_loaded --IF NOT p_is_completed --ER13869750
2234: THEN
2235: l_from_generic :=
2236: l_from_generic || 'mtl_material_transactions_temp mmtt ';
2237:
2238: --IF g_op_plan_instance_id_visible = 'T' AND
2239: IF wms_plan_tasks_pvt.g_query_planned_tasks = TRUE
2240: THEN

Line 10925: p_transaction_temp_id IN mtl_material_transactions_temp.transaction_temp_id%TYPE,

10921: x_msg_data := SQLERRM;
10922: END query_tasks;
10923:
10924: FUNCTION getforcesignonflagvalue (
10925: p_transaction_temp_id IN mtl_material_transactions_temp.transaction_temp_id%TYPE,
10926: p_device_id OUT NOCOPY NUMBER
10927: )
10928: RETURN VARCHAR2
10929: IS

Line 10938: FROM mtl_material_transactions_temp mmtt

10934: mmtt.subinventory_code,
10935: mmtt.locator_id
10936: )
10937: INTO p_device_id
10938: FROM mtl_material_transactions_temp mmtt
10939: WHERE mmtt.transaction_temp_id = p_transaction_temp_id;
10940:
10941: SELECT force_sign_on_flag
10942: INTO l_force_sign_on

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 11097: wdt2.transaction_temp_id IN( SELECT transaction_temp_id FROM mtl_material_transactions_temp mmtt1

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
11098: WHERE DECODE(wdt.TASK_METHOD,
11099: 'CARTON', mmtt1.cartonization_id,
11100: 'PICK_SLIP', mmtt1.pick_slip_number,
11101: 'DISCRETE', mmtt1.pick_slip_number,

Line 11562: TYPE transaction_temp_id_table_type IS TABLE OF mtl_material_transactions_temp.transaction_temp_id%TYPE

11558: x_msg_data OUT NOCOPY VARCHAR2,
11559: x_msg_count OUT NOCOPY NUMBER
11560: )
11561: IS
11562: TYPE transaction_temp_id_table_type IS TABLE OF mtl_material_transactions_temp.transaction_temp_id%TYPE
11563: INDEX BY BINARY_INTEGER;
11564:
11565: TYPE wms_task_status_table_type IS TABLE OF mtl_material_transactions_temp.wms_task_status%TYPE
11566: INDEX BY BINARY_INTEGER;

Line 11565: TYPE wms_task_status_table_type IS TABLE OF mtl_material_transactions_temp.wms_task_status%TYPE

11561: IS
11562: TYPE transaction_temp_id_table_type IS TABLE OF mtl_material_transactions_temp.transaction_temp_id%TYPE
11563: INDEX BY BINARY_INTEGER;
11564:
11565: TYPE wms_task_status_table_type IS TABLE OF mtl_material_transactions_temp.wms_task_status%TYPE
11566: INDEX BY BINARY_INTEGER;
11567:
11568: TYPE task_priority_table_type IS TABLE OF mtl_material_transactions_temp.task_priority%TYPE
11569: INDEX BY BINARY_INTEGER;

Line 11568: TYPE task_priority_table_type IS TABLE OF mtl_material_transactions_temp.task_priority%TYPE

11564:
11565: TYPE wms_task_status_table_type IS TABLE OF mtl_material_transactions_temp.wms_task_status%TYPE
11566: INDEX BY BINARY_INTEGER;
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;

Line 11620: FROM mtl_material_transactions_temp

11616: --Get the transaction_temp_id of the children tasks
11617: CURSOR bulk_children_tasks_cur(trx_temp_id NUMBER)
11618: IS
11619: SELECT transaction_temp_id
11620: FROM mtl_material_transactions_temp
11621: WHERE parent_line_id = trx_temp_id
11622: AND transaction_temp_id <> trx_temp_id
11623: FOR UPDATE nowait;
11624: --end bulk picking

Line 11673: FROM mtl_material_transactions_temp mmtt,

11669: IF rec_wwtt.task_type_id <> 3
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(+)

Line 11800: UPDATE mtl_material_transactions_temp

11796:
11797: IF l_non_cycle_count_number > 0
11798: THEN
11799: FORALL i IN l_transaction_temp_id_table.FIRST .. l_transaction_temp_id_table.LAST
11800: UPDATE mtl_material_transactions_temp
11801: SET wms_task_status =
11802: DECODE (l_wms_task_status_table (i),
11803: 8, 8,
11804: 1, 1,