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 497: mtl_material_transactions_temp mmtt

493: --wwtt used to get the parent task.
494: SELECT COUNT (1), wwtt.transaction_temp_id
495: BULK COLLECT INTO l_num_of_child_tasks_tbl, l_parent_temp_ids_tbl
496: FROM wms_waveplan_tasks_temp wwtt,
497: mtl_material_transactions_temp mmtt
498: WHERE wwtt.transaction_temp_id = mmtt.parent_line_id
499: AND wwtt.transaction_temp_id <> mmtt.transaction_temp_id
500: GROUP BY wwtt.transaction_temp_id;
501:

Line 1938: l_from_generic || 'mtl_material_transactions_temp mmtt ';

1934:
1935: IF NOT p_is_completed
1936: THEN
1937: l_from_generic :=
1938: l_from_generic || 'mtl_material_transactions_temp mmtt ';
1939:
1940: --IF g_op_plan_instance_id_visible = 'T' AND
1941: IF wms_plan_tasks_pvt.g_query_planned_tasks = TRUE
1942: THEN

Line 9920: p_transaction_temp_id IN mtl_material_transactions_temp.transaction_temp_id%TYPE,

9916: x_msg_data := SQLERRM;
9917: END query_tasks;
9918:
9919: FUNCTION getforcesignonflagvalue (
9920: p_transaction_temp_id IN mtl_material_transactions_temp.transaction_temp_id%TYPE,
9921: p_device_id OUT NOCOPY NUMBER
9922: )
9923: RETURN VARCHAR2
9924: IS

Line 9933: FROM mtl_material_transactions_temp mmtt

9929: mmtt.subinventory_code,
9930: mmtt.locator_id
9931: )
9932: INTO p_device_id
9933: FROM mtl_material_transactions_temp mmtt
9934: WHERE mmtt.transaction_temp_id = p_transaction_temp_id;
9935:
9936: SELECT force_sign_on_flag
9937: INTO l_force_sign_on

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

10079:
10080: --BUG: 4707588
10081: SELECT wwtt.transaction_temp_id, wwtt.task_type_id, wwtt.status
10082: BULK COLLECT INTO l_transaction_temp_ids, l_task_type_ids, l_statuses
10083: FROM wms_waveplan_tasks_temp wwtt, mtl_material_transactions_temp mmtt, WMS_DISPATCHED_TASKS wdt
10084: WHERE wwtt.transaction_temp_id = wdt.transaction_temp_id AND
10085: wwtt.transaction_temp_id = mmtt.transaction_temp_id AND
10086: wwtt.RESULT = 'X' AND
10087: wwtt.status_id = 3 AND

Line 10092: wdt2.transaction_temp_id IN( SELECT transaction_temp_id FROM mtl_material_transactions_temp mmtt1

10088: EXISTS ( SELECT 1 FROM WMS_DISPATCHED_TASKS wdt2
10089: WHERE wdt2.person_id = wwtt.person_id AND
10090: wdt2.status = 9 AND
10091: wdt2.task_method IS NOT NULL AND
10092: wdt2.transaction_temp_id IN( SELECT transaction_temp_id FROM mtl_material_transactions_temp mmtt1
10093: WHERE DECODE(wdt.TASK_METHOD,
10094: 'CARTON', mmtt1.cartonization_id,
10095: 'PICK_SLIP', mmtt1.pick_slip_number,
10096: 'DISCRETE', mmtt1.pick_slip_number,

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

10553: x_msg_data OUT NOCOPY VARCHAR2,
10554: x_msg_count OUT NOCOPY NUMBER
10555: )
10556: IS
10557: TYPE transaction_temp_id_table_type IS TABLE OF mtl_material_transactions_temp.transaction_temp_id%TYPE
10558: INDEX BY BINARY_INTEGER;
10559:
10560: TYPE wms_task_status_table_type IS TABLE OF mtl_material_transactions_temp.wms_task_status%TYPE
10561: INDEX BY BINARY_INTEGER;

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

10556: IS
10557: TYPE transaction_temp_id_table_type IS TABLE OF mtl_material_transactions_temp.transaction_temp_id%TYPE
10558: INDEX BY BINARY_INTEGER;
10559:
10560: TYPE wms_task_status_table_type IS TABLE OF mtl_material_transactions_temp.wms_task_status%TYPE
10561: INDEX BY BINARY_INTEGER;
10562:
10563: TYPE task_priority_table_type IS TABLE OF mtl_material_transactions_temp.task_priority%TYPE
10564: INDEX BY BINARY_INTEGER;

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

10559:
10560: TYPE wms_task_status_table_type IS TABLE OF mtl_material_transactions_temp.wms_task_status%TYPE
10561: INDEX BY BINARY_INTEGER;
10562:
10563: TYPE task_priority_table_type IS TABLE OF mtl_material_transactions_temp.task_priority%TYPE
10564: INDEX BY BINARY_INTEGER;
10565:
10566: TYPE person_id_table_type IS TABLE OF wms_dispatched_tasks.person_id%TYPE
10567: INDEX BY BINARY_INTEGER;

Line 10615: FROM mtl_material_transactions_temp

10611: --Get the transaction_temp_id of the children tasks
10612: CURSOR bulk_children_tasks_cur(trx_temp_id NUMBER)
10613: IS
10614: SELECT transaction_temp_id
10615: FROM mtl_material_transactions_temp
10616: WHERE parent_line_id = trx_temp_id
10617: AND transaction_temp_id <> trx_temp_id
10618: FOR UPDATE nowait;
10619: --end bulk picking

Line 10668: FROM mtl_material_transactions_temp mmtt,

10664: IF rec_wwtt.task_type_id <> 3
10665: THEN
10666: SELECT mmtt.transaction_temp_id
10667: INTO l_transaction_temp_id_table (i)
10668: FROM mtl_material_transactions_temp mmtt,
10669: wms_dispatched_tasks wdt
10670: WHERE mmtt.transaction_temp_id =
10671: rec_wwtt.transaction_temp_id
10672: AND mmtt.transaction_temp_id = wdt.transaction_temp_id(+)

Line 10795: UPDATE mtl_material_transactions_temp

10791:
10792: IF l_non_cycle_count_number > 0
10793: THEN
10794: FORALL i IN l_transaction_temp_id_table.FIRST .. l_transaction_temp_id_table.LAST
10795: UPDATE mtl_material_transactions_temp
10796: SET wms_task_status =
10797: DECODE (l_wms_task_status_table (i),
10798: 8, 8,
10799: 1, 1,