DBA Data[Home] [Help]

APPS.WMS_TASK_DISPATCH_GEN dependencies on MTL_TXN_REQUEST_LINES

Line 5061: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mol

5057: l_ret VARCHAR2(1) := 'X';
5058: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5059: CURSOR c_cancelled_tasks IS
5060: SELECT decode(mmtt.transaction_type_id, 35,'N',51,'N','Y')
5061: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mol
5062: WHERE (mmtt.transaction_temp_id = txn_temp_id OR mmtt.parent_line_id = txn_temp_id)
5063: AND mmtt.move_order_line_id = mol.line_id
5064: AND mol.line_status = inv_globals.g_to_status_cancel_by_source
5065: AND ROWNUM = 1;

Line 5889: FROM mtl_txn_request_lines

5885:
5886:
5887: BEGIN
5888: SELECT uom_code INTO l_mol_uom
5889: FROM mtl_txn_request_lines
5890: WHERE line_id = l_move_order_line_id;
5891:
5892: mydebug('load_pick: l_mol_uom_code: '||l_mol_uom);
5893: EXCEPTION

Line 5935: update mtl_txn_request_lines

5931:
5932: mydebug('load_pick: Updating move order line with reduced
5933: quantity');
5934:
5935: update mtl_txn_request_lines
5936: set quantity_detailed = quantity_detailed - l_mol_delta_qty
5937: where line_id = l_move_order_line_id;
5938:
5939: mydebug('load_pick: after updating move order line detailed

Line 8049: FROM mtl_txn_request_lines mol, mtl_material_transactions_temp mmtt

8045: AND mmtt.transaction_temp_id = p_temp_id;
8046:
8047: CURSOR current_carton_grouping_cursor IS
8048: SELECT mol.carton_grouping_id
8049: FROM mtl_txn_request_lines mol, mtl_material_transactions_temp mmtt
8050: WHERE mmtt.transaction_temp_id = p_temp_id
8051: AND mmtt.organization_id = mol.organization_id
8052: AND mmtt.move_order_line_id = mol.line_id;
8053:

Line 8056: FROM mtl_txn_request_lines mol, mtl_material_transactions_temp mmtt

8052: AND mmtt.move_order_line_id = mol.line_id;
8053:
8054: CURSOR others_carton_grouping_cursor(p_lpn_id IN NUMBER) IS
8055: SELECT DISTINCT mol.carton_grouping_id
8056: FROM mtl_txn_request_lines mol, mtl_material_transactions_temp mmtt
8057: WHERE mmtt.transfer_lpn_id = p_lpn_id
8058: AND mmtt.organization_id = mol.organization_id
8059: AND mmtt.move_order_line_id = mol.line_id;
8060: BEGIN

Line 8162: , mtl_txn_request_lines mtrl

8158: INTO l_mmtt_mo_type
8159: , l_mmtt_txn_type_id
8160: , l_mmtt_wip_entity_type
8161: FROM mtl_txn_request_headers mtrh
8162: , mtl_txn_request_lines mtrl
8163: , mtl_material_transactions_temp mmtt
8164: WHERE mtrh.header_id = mtrl.header_id
8165: AND mtrl.line_id = mmtt.move_order_line_id
8166: AND mmtt.transaction_temp_id = p_temp_id;

Line 8176: , mtl_txn_request_lines mtrl

8172: , mmtt.wip_entity_type
8173: INTO l_mo_type_in_lpn
8174: , l_wip_entity_type_in_lpn
8175: FROM mtl_txn_request_headers mtrh
8176: , mtl_txn_request_lines mtrl
8177: , mtl_material_transactions_temp mmtt
8178: WHERE mtrh.header_id = mtrl.header_id
8179: AND mtrl.line_id = mmtt.move_order_line_id
8180: AND mmtt.transfer_lpn_id = pick_to_lpn_rec.lpn_id

Line 10791: MTL_TXN_REQUEST_LINES MTRL,

10787: wdd.batch_id,
10788: wrd.demand_type_id
10789: FROM
10790: wms_replenishment_details WRD,
10791: MTL_TXN_REQUEST_LINES MTRL,
10792: WSH_DELIVERY_DETAILS WDD
10793: WHERE WRD.ORGANIZATION_ID = P_ORG_ID
10794: AND WRD.SOURCE_LINE_ID = p_mo_line_id
10795: AND wrd.demand_type_id <> 4 -- true only for first level of REPL

Line 10812: MTL_TXN_REQUEST_LINES MTRL

10808: wrd.repl_level, -- TO DECIDE WHETHER TO PICK_RELEASE DEMAND OR allocate repl MO FOR LEVEL > 1
10809: wrd.demand_type_id
10810: FROM
10811: wms_replenishment_details WRD,
10812: MTL_TXN_REQUEST_LINES MTRL
10813: WHERE WRD.ORGANIZATION_ID = P_ORG_ID
10814: AND WRD.SOURCE_LINE_ID = p_mo_line_id
10815: AND wrd.demand_type_id = 4 -- true for multi level repl (>1)
10816: AND WRD.SOURCE_LINE_ID = MTRL.LINE_ID

Line 13825: FROM mtl_txn_request_headers mtrh, mtl_txn_request_lines mtrl

13821: , mtrl.quantity
13822: , mtrl.uom_code
13823: , nvl(mtrl.quantity_delivered,0)
13824: , mtrl.line_status --bug3139307
13825: FROM mtl_txn_request_headers mtrh, mtl_txn_request_lines mtrl
13826: WHERE mtrl.line_id = l_mo_line_id
13827: AND mtrh.header_id = mtrl.header_id;
13828:
13829: CURSOR c_get_other_mmtt IS

Line 13971: UPDATE mtl_txn_request_lines

13967: RAISE fnd_api.g_exc_error;
13968: END IF;
13969: -- Bug 2924823 H to I
13970: if (l_wf <= 0) or (p_qty_rsn_id <= 0) then
13971: UPDATE mtl_txn_request_lines
13972: SET quantity_detailed = quantity_detailed - l_txn_qty
13973: WHERE line_id = l_mo_line_id;
13974: end if;
13975: ELSE

Line 14059: UPDATE mtl_txn_request_lines

14055: END IF;
14056: END IF; --bug3139307 bug 2924823 H to I
14057: /* IF l_mo_type = INV_GLOBALS.G_MOVE_ORDER_MFG_PICK THEN */
14058: ELSIF l_mo_type IN (5,7)THEN -- wip picking bug 2924823 H to I
14059: UPDATE mtl_txn_request_lines
14060: SET quantity_detailed = quantity_delivered
14061: , line_status = 5
14062: WHERE line_id = l_mo_line_id;
14063:

Line 14102: UPDATE mtl_txn_request_lines

14098: RAISE fnd_api.g_exc_error;
14099: END IF;
14100: -- Bug 2924823 H to I
14101: if (l_wf <= 0) or (p_qty_rsn_id <= 0) then
14102: UPDATE mtl_txn_request_lines
14103: SET quantity_detailed = quantity_detailed - l_txn_qty,
14104: line_status = 5
14105: WHERE line_id = l_mo_line_id;
14106: end if;

Line 14108: UPDATE mtl_txn_request_lines

14104: line_status = 5
14105: WHERE line_id = l_mo_line_id;
14106: end if;
14107: ELSIF l_mo_type IN (INV_GLOBALS.G_MOVE_ORDER_REQUISITION, INV_GLOBALS.G_MOVE_ORDER_REPLENISHMENT) THEN
14108: UPDATE mtl_txn_request_lines
14109: SET quantity_detailed = quantity_delivered
14110: WHERE line_id = l_mo_line_id;
14111:
14112: inv_trx_util_pub.delete_transaction(

Line 14150: UPDATE mtl_txn_request_lines

14146: END IF;
14147:
14148: -- Bug 2924823 H to I
14149: if (l_wf <= 0) or (p_qty_rsn_id <= 0) then
14150: UPDATE mtl_txn_request_lines
14151: SET quantity_detailed = quantity_delivered
14152: WHERE line_id = l_mo_line_id;
14153: end if;
14154: END IF;

Line 14471: mtl_txn_request_lines mtrl, mtl_material_transactions_temp mmtt

14467: mtrl.txn_source_id
14468: INTO l_mmtt_mo_type,
14469: l_txn_source_id --Bug#9659710
14470: FROM mtl_txn_request_headers mtrh, -- mo header for the new task
14471: mtl_txn_request_lines mtrl, mtl_material_transactions_temp mmtt
14472: WHERE mtrh.header_id = mtrl.header_id
14473: AND mtrl.line_id = mmtt.move_order_line_id
14474: AND mmtt.transaction_temp_id = p_temp_id;
14475:

Line 14606: mtl_txn_request_lines mtrl, mtl_material_transactions_temp mmtt

14602:
14603: SELECT mtrh.move_order_type
14604: INTO l_mmtt_mo_type
14605: FROM mtl_txn_request_headers mtrh, -- mo header for the new task
14606: mtl_txn_request_lines mtrl, mtl_material_transactions_temp mmtt
14607: WHERE mtrh.header_id = mtrl.header_id
14608: AND mtrl.line_id = mmtt.move_order_line_id
14609: AND mmtt.transaction_temp_id = p_temp_id;
14610:

Line 16071: FROM mtl_txn_request_lines

16067: BEGIN
16068:
16069: SELECT line_status
16070: INTO l_mo_line_status
16071: FROM mtl_txn_request_lines
16072: WHERE line_id = p_mo_line_id
16073: AND organization_id = p_organization_id;
16074:
16075: IF (l_debug = 1) THEN

Line 16142: UPDATE mtl_txn_request_lines

16138:
16139: END IF;
16140:
16141: IF (l_mo_line_status <> 5 AND l_mmtt_exists = 0 AND l_kill_mo_profile = 1) THEN -- Only if MOL is not closed, no MMTT (There can be loaded MMTT), and Fill Kill Yes
16142: UPDATE mtl_txn_request_lines
16143: SET line_status = 5
16144: WHERE line_id = p_mo_line_id;
16145:
16146: IF (l_debug = 1) THEN