[Home] [Help]
113: );
114: TYPE split_mo_tb_tp IS TABLE OF mol_in_rec INDEX BY BINARY_INTEGER;
115:
116: -- Task Record
117: SUBTYPE task_rec IS wms_dispatched_tasks%ROWTYPE;
118:
119: --Added for bug 5286880
120: g_line_rows WSH_UTIL_CORE.id_tab_type;
121: g_grouping_rows WSH_UTIL_CORE.id_tab_type;
2501: WHERE p_drop_type <> G_DT_DROP_ALL
2502: AND wln.lpn_id = p_lpn_id
2503: UNION ALL
2504: SELECT wln.outermost_lpn_id
2505: FROM wms_dispatched_tasks wdt
2506: ,mtl_txn_request_lines mtrl
2507: ,mtl_material_transactions_temp mmtt
2508: ,mtl_txn_request_headers mtrh
2509: ,wms_license_plate_numbers wln
2759: mmtt.error_explanation
2760: --R12 End
2761: FROM mtl_material_transactions_temp mmtt
2762: ,mtl_txn_request_lines mtrl
2763: ,wms_dispatched_tasks wdt
2764: --,mtl_item_locations milk
2765: ,mtl_system_items_kfv msik
2766: ,mtl_txn_request_headers mtrh
2767: ,wms_license_plate_numbers wln
5081: CURSOR c_mol_mmtt_cursor IS
5082: SELECT mmtt.transaction_temp_id
5083: FROM mtl_material_transactions_temp mmtt
5084: ,mtl_txn_request_lines mtrl
5085: ,wms_dispatched_tasks wdt
5086: ,(SELECT lpn_id FROM wms_license_plate_numbers /*Bug5723418.*/
5087: START WITH lpn_id = p_lpn_id
5088: CONNECT BY PRIOR lpn_id = parent_lpn_id
5089: ) wlpn
5114: -- (p_group_id = -1). In this cursor, select all the tasks that
5115: -- have drop active op plan or tasks that have wdt status 4 (loaded).
5116: CURSOR c_all_mmtt_cursor IS
5117: SELECT mmtt.transaction_temp_id
5118: FROM wms_dispatched_tasks wdt
5119: ,mtl_txn_request_lines mtrl
5120: ,mtl_material_transactions_temp mmtt
5121: ,mtl_txn_request_headers mtrh
5122: WHERE mtrh.header_id = mtrl.header_id
5147: (mmtt.operation_plan_id IS NULL))
5148: AND p_drop_all <> 'Y'
5149: UNION ALL
5150: SELECT mmtt.transaction_temp_id
5151: FROM wms_dispatched_tasks wdt
5152: ,mtl_txn_request_lines mtrl
5153: ,mtl_material_transactions_temp mmtt
5154: ,mtl_txn_request_headers mtrh
5155: WHERE mtrh.header_id = mtrl.header_id
5416:
5417: IF (l_lpn_context IN (g_lpn_context_inv,g_lpn_context_wip)) THEN
5418: --Delete WDT
5419: BEGIN
5420: DELETE FROM wms_dispatched_tasks
5421: WHERE transaction_temp_id = l_tempid_tab(i);
5422: EXCEPTION
5423: WHEN OTHERS THEN
5424: IF (l_debug = 1) THEN
5916: -- Check if the lPN is alredy loaded
5917: BEGIN
5918: SELECT 'Y' INTO x_loaded_status FROM dual where exists
5919: (SELECT 1 from
5920: wms_dispatched_tasks W,
5921: mtl_material_transactions_temp t,
5922: mtl_txn_request_lines M
5923: WHERE m.lpn_id = p_lpn_id
5924: AND m.organization_id = p_org_id
5939: begin
5940: if (x_lpn_context =1 and x_loaded_status = 'N' ) then
5941: -- SELECT 'Y' INTO x_loaded_status FROM dual where exists
5942: SELECT 'Z' INTO x_loaded_status FROM dual where exists -- End of changes for the bug 5768339.
5943: (SELECT 1 FROM mtl_material_transactions_temp mmtt, wms_dispatched_tasks wdt
5944: WHERE mmtt.transaction_temp_id = wdt.transaction_temp_id
5945: AND mmtt.organization_id = wdt.organization_id
5946: AND wdt.status = 4
5947: AND wdt.organization_id = p_org_id
6113: IF l_entire_lpn_empty THEN
6114: BEGIN
6115: SELECT 'Y' INTO x_loaded_status FROM dual where exists
6116: (select 1 from
6117: WMS_DISPATCHED_TASKS W, MTL_MATERIAL_TRANSACTIONS_TEMP T
6118: WHERE T.lpn_id = l_lpn_id
6119: AND t.organization_id = p_org_id
6120: AND w.organization_id = p_org_id
6121: AND T.transaction_temp_id = W.transaction_temp_id
6514: l_txn_temp_id NUMBER;
6515: TYPE number_tb_tp IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
6516: l_mmtt_ids number_tb_tp;
6517: l_emp_id NUMBER;
6518: l_task_execute_rec wms_dispatched_tasks%ROWTYPE;
6519: l_error_code NUMBER;
6520:
6521: l_consolidation_method_id NUMBER;
6522: l_drop_lpn_option NUMBER;
7903: l_to_sub VARCHAR2(10);
7904: l_to_loc NUMBER;
7905: l_ser_trx_id NUMBER;
7906: l_return_status NUMBER;
7907: l_task_execute_rec wms_dispatched_tasks%ROWTYPE;
7908: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7909: l_progress VARCHAR2(10) := '0';
7910: l_user_id NUMBER;
7911: l_emp_id NUMBER;
10880: --Need to update the drop_off_time on WDT for all the tasks
10881: l_progress := '228';
10882:
10883: BEGIN
10884: UPDATE wms_dispatched_tasks
10885: SET drop_off_time = l_drop_off_time
10886: WHERE transaction_temp_id = l_mmtt_temp_id;
10887: EXCEPTION
10888: WHEN OTHERS THEN
11531: with mmmt and mtrl table.
11532: */
11533: (EXISTS (SELECT 'LOADED_BY_SAME_USER'
11534: FROM mtl_material_transactions_temp mmtt,
11535: wms_dispatched_tasks wdt,--5650113
11536: mtl_txn_request_lines mtrl--5650113
11537: WHERE mmtt.organization_id = p_organization_id
11538: AND mmtt.transaction_temp_id = wdt.transaction_temp_id
11539: AND wdt.organization_id = p_organization_id
11774: wlpn.lpn_context IN (1,3) AND l_lpn_context = 3)--BUG 3463634
11775: AND (p_lpn_id = wlpn.lpn_id OR --BUG 3368408
11776: (NOT EXISTS (SELECT 'LOADED'
11777: FROM mtl_material_transactions_temp mmtt,
11778: wms_dispatched_tasks wdt
11779: WHERE mmtt.organization_id = p_organization_id
11780: AND mmtt.transaction_temp_id = wdt.transaction_temp_id
11781: AND wdt.organization_id = p_organization_id
11782: AND wdt.task_type = 2