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

Line 118: SUBTYPE task_rec IS wms_dispatched_tasks%ROWTYPE;

114: );
115: TYPE split_mo_tb_tp IS TABLE OF mol_in_rec INDEX BY BINARY_INTEGER;
116:
117: -- Task Record
118: SUBTYPE task_rec IS wms_dispatched_tasks%ROWTYPE;
119:
120: --Added for bug 5286880
121: g_line_rows WSH_UTIL_CORE.id_tab_type;
122: g_grouping_rows WSH_UTIL_CORE.id_tab_type;

Line 681: ,wms_dispatched_tasks wdt

677: mmtt.secondary_transaction_quantity, -- 9037915
678: mmtt.secondary_uom_code -- 9037915
679: FROM mtl_material_transactions_temp mmtt
680: ,mtl_txn_request_lines mtrl
681: ,wms_dispatched_tasks wdt
682: --,mtl_item_locations milk
683: ,mtl_system_items_kfv msik
684: ,mtl_txn_request_headers mtrh
685: WHERE wdt.organization_id = p_organization_id

Line 3132: FROM wms_dispatched_tasks wdt

3128: ,lpn_context
3129: FROM wms_license_plate_numbers wln
3130: START WITH LPN_ID IN (
3131: SELECT DISTINCT wln2.outermost_lpn_id
3132: FROM wms_dispatched_tasks wdt
3133: ,mtl_txn_request_lines mtrl
3134: ,mtl_material_transactions_temp mmtt
3135: ,mtl_txn_request_headers mtrh
3136: ,wms_license_plate_numbers wln2

Line 3408: ,wms_dispatched_tasks wdt

3404: mmtt.error_explanation
3405: --R12 End
3406: FROM mtl_material_transactions_temp mmtt
3407: ,mtl_txn_request_lines mtrl
3408: ,wms_dispatched_tasks wdt
3409: --,mtl_item_locations milk
3410: ,mtl_system_items_kfv msik
3411: ,mtl_txn_request_headers mtrh
3412: ,wms_license_plate_numbers wln

Line 5792: ,wms_dispatched_tasks wdt

5788: CURSOR c_mol_mmtt_cursor IS
5789: SELECT mmtt.transaction_temp_id
5790: FROM mtl_material_transactions_temp mmtt
5791: ,mtl_txn_request_lines mtrl
5792: ,wms_dispatched_tasks wdt
5793: ,(SELECT lpn_id FROM wms_license_plate_numbers /*Bug5723418.*/
5794: START WITH lpn_id = p_lpn_id
5795: CONNECT BY PRIOR lpn_id = parent_lpn_id
5796: ) wlpn

Line 5825: FROM wms_dispatched_tasks wdt

5821: -- (p_group_id = -1). In this cursor, select all the tasks that
5822: -- have drop active op plan or tasks that have wdt status 4 (loaded).
5823: CURSOR c_all_mmtt_cursor IS
5824: SELECT mmtt.transaction_temp_id
5825: FROM wms_dispatched_tasks wdt
5826: ,mtl_txn_request_lines mtrl
5827: ,mtl_material_transactions_temp mmtt
5828: ,mtl_txn_request_headers mtrh
5829: WHERE mtrh.header_id = mtrl.header_id

Line 5858: FROM wms_dispatched_tasks wdt

5854: (mmtt.operation_plan_id IS NULL))
5855: AND p_drop_all <> 'Y'
5856: UNION ALL
5857: SELECT mmtt.transaction_temp_id
5858: FROM wms_dispatched_tasks wdt
5859: ,mtl_txn_request_lines mtrl
5860: ,mtl_material_transactions_temp mmtt
5861: ,mtl_txn_request_headers mtrh
5862: WHERE mtrh.header_id = mtrl.header_id

Line 6149: DELETE FROM wms_dispatched_tasks

6145:
6146: IF (l_lpn_context IN (g_lpn_context_inv,g_lpn_context_wip)) THEN
6147: --Delete WDT
6148: BEGIN
6149: DELETE FROM wms_dispatched_tasks
6150: WHERE transaction_temp_id = l_tempid_tab(i);
6151: EXCEPTION
6152: WHEN OTHERS THEN
6153: IF (l_debug = 1) THEN

Line 6652: wms_dispatched_tasks W,

6648: -- Check if the lPN is alredy loaded
6649: BEGIN
6650: SELECT 'Y' INTO x_loaded_status FROM dual where exists
6651: (SELECT 1 from
6652: wms_dispatched_tasks W,
6653: mtl_material_transactions_temp t,
6654: mtl_txn_request_lines M
6655: WHERE m.lpn_id = p_lpn_id
6656: AND m.organization_id = p_org_id

Line 6678: FROM wms_dispatched_tasks W,

6674: WHERE parent_lpn_id = p_lpn_id AND organization_id = p_org_id
6675: GROUP BY inventory_item_id,organization_id) LOOP
6676: l_mmtt_qty := 0;
6677: SELECT Sum(mmtt.primary_quantity) INTO l_mmtt_qty
6678: FROM wms_dispatched_tasks W,
6679: mtl_material_transactions_temp mmtt,
6680: mtl_txn_request_lines M
6681: WHERE m.lpn_id = p_lpn_id
6682: AND m.organization_id = x.organization_id

Line 6712: (SELECT 1 FROM mtl_material_transactions_temp mmtt, wms_dispatched_tasks wdt

6708: begin
6709: if (x_lpn_context =1 and x_loaded_status = 'N' ) then
6710: -- SELECT 'Y' INTO x_loaded_status FROM dual where exists
6711: SELECT 'Z' INTO x_loaded_status FROM dual where exists -- End of changes for the bug 5768339.
6712: (SELECT 1 FROM mtl_material_transactions_temp mmtt, wms_dispatched_tasks wdt
6713: WHERE mmtt.transaction_temp_id = wdt.transaction_temp_id
6714: AND mmtt.organization_id = wdt.organization_id
6715: AND wdt.status = 4
6716: AND wdt.organization_id = p_org_id

Line 6783: AND NOT EXISTS ( SELECT 1 FROM Wms_dispatched_tasks wdt

6779: AND mmtt.wms_task_type <> WMS_GLOBALS.g_wms_task_type_putaway
6780: AND wlpn.outermost_lpn_id = p_lpn_id
6781: AND wlpn.organization_id = p_org_id
6782: AND mmtt.allocated_lpn_id = wlpn.lpn_id
6783: AND NOT EXISTS ( SELECT 1 FROM Wms_dispatched_tasks wdt
6784: WHERE wdt.transaction_temp_id = mmtt.transaction_temp_id
6785: AND wdt.status >= G_TASK_STATUS_LOADED ) ;
6786:
6787: IF ( l_invalid_cnt > 0 ) THEN

Line 6928: WMS_DISPATCHED_TASKS W, MTL_MATERIAL_TRANSACTIONS_TEMP T

6924: IF l_entire_lpn_empty THEN
6925: BEGIN
6926: SELECT 'Y' INTO x_loaded_status FROM dual where exists
6927: (select 1 from
6928: WMS_DISPATCHED_TASKS W, MTL_MATERIAL_TRANSACTIONS_TEMP T
6929: WHERE T.lpn_id = l_lpn_id
6930: AND t.organization_id = p_org_id
6931: AND w.organization_id = p_org_id
6932: AND T.transaction_temp_id = W.transaction_temp_id

Line 7380: l_task_execute_rec wms_dispatched_tasks%ROWTYPE;

7376: l_txn_temp_id NUMBER;
7377: TYPE number_tb_tp IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
7378: l_mmtt_ids number_tb_tp;
7379: l_emp_id NUMBER;
7380: l_task_execute_rec wms_dispatched_tasks%ROWTYPE;
7381: l_error_code NUMBER;
7382:
7383: l_consolidation_method_id NUMBER;
7384: l_drop_lpn_option NUMBER;

Line 8769: l_task_execute_rec wms_dispatched_tasks%ROWTYPE;

8765: l_to_sub VARCHAR2(10);
8766: l_to_loc NUMBER;
8767: l_ser_trx_id NUMBER;
8768: l_return_status NUMBER;
8769: l_task_execute_rec wms_dispatched_tasks%ROWTYPE;
8770: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
8771: l_progress VARCHAR2(10) := '0';
8772: l_user_id NUMBER;
8773: l_emp_id NUMBER;

Line 11804: UPDATE wms_dispatched_tasks

11800: --Need to update the drop_off_time on WDT for all the tasks
11801: l_progress := '228';
11802:
11803: BEGIN
11804: UPDATE wms_dispatched_tasks
11805: SET drop_off_time = l_drop_off_time
11806: WHERE transaction_temp_id = l_mmtt_temp_id;
11807: EXCEPTION
11808: WHEN OTHERS THEN

Line 12514: wms_dispatched_tasks wdt,--5650113

12510: with mmmt and mtrl table.
12511: */
12512: (EXISTS (SELECT 'LOADED_BY_SAME_USER'
12513: FROM mtl_material_transactions_temp mmtt,
12514: wms_dispatched_tasks wdt,--5650113
12515: mtl_txn_request_lines mtrl--5650113
12516: WHERE mmtt.organization_id = p_organization_id
12517: AND mmtt.transaction_temp_id = wdt.transaction_temp_id
12518: AND wdt.organization_id = p_organization_id

Line 12879: wms_dispatched_tasks wdt

12875: wlpn.lpn_context IN (1,3,11) AND l_lpn_context = 3)--BUG 3463634 --BUG#11769042(Adding LPN context 11)
12876: AND (p_lpn_id = wlpn.lpn_id OR --BUG 3368408
12877: (NOT EXISTS (SELECT 'LOADED'
12878: FROM mtl_material_transactions_temp mmtt,
12879: wms_dispatched_tasks wdt
12880: WHERE mmtt.organization_id = p_organization_id
12881: AND mmtt.transaction_temp_id = wdt.transaction_temp_id
12882: AND wdt.organization_id = p_organization_id
12883: AND wdt.task_type = 2

Line 13826: wms_dispatched_tasks

13822: ) ;
13823: --delete WDT
13824: DELETE
13825: FROM
13826: wms_dispatched_tasks
13827: WHERE
13828: transaction_temp_id IN
13829: (
13830: SELECT