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_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 10760: MTL_TXN_REQUEST_LINES MTRL,

10756: wdd.batch_id,
10757: wrd.demand_type_id
10758: FROM
10759: wms_replenishment_details WRD,
10760: MTL_TXN_REQUEST_LINES MTRL,
10761: WSH_DELIVERY_DETAILS WDD
10762: WHERE WRD.ORGANIZATION_ID = P_ORG_ID
10763: AND WRD.SOURCE_LINE_ID = p_mo_line_id
10764: AND wrd.demand_type_id <> 4 -- true only for first level of REPL

Line 10781: MTL_TXN_REQUEST_LINES MTRL

10777: wrd.repl_level, -- TO DECIDE WHETHER TO PICK_RELEASE DEMAND OR allocate repl MO FOR LEVEL > 1
10778: wrd.demand_type_id
10779: FROM
10780: wms_replenishment_details WRD,
10781: MTL_TXN_REQUEST_LINES MTRL
10782: WHERE WRD.ORGANIZATION_ID = P_ORG_ID
10783: AND WRD.SOURCE_LINE_ID = p_mo_line_id
10784: AND wrd.demand_type_id = 4 -- true for multi level repl (>1)
10785: AND WRD.SOURCE_LINE_ID = MTRL.LINE_ID

Line 13572: FROM mtl_txn_request_headers mtrh, mtl_txn_request_lines mtrl

13568: , mtrl.quantity
13569: , mtrl.uom_code
13570: , nvl(mtrl.quantity_delivered,0)
13571: , mtrl.line_status --bug3139307
13572: FROM mtl_txn_request_headers mtrh, mtl_txn_request_lines mtrl
13573: WHERE mtrl.line_id = l_mo_line_id
13574: AND mtrh.header_id = mtrl.header_id;
13575:
13576: CURSOR c_get_other_mmtt IS

Line 13718: UPDATE mtl_txn_request_lines

13714: RAISE fnd_api.g_exc_error;
13715: END IF;
13716: -- Bug 2924823 H to I
13717: if (l_wf <= 0) or (p_qty_rsn_id <= 0) then
13718: UPDATE mtl_txn_request_lines
13719: SET quantity_detailed = quantity_detailed - l_txn_qty
13720: WHERE line_id = l_mo_line_id;
13721: end if;
13722: ELSE

Line 13806: UPDATE mtl_txn_request_lines

13802: END IF;
13803: END IF; --bug3139307 bug 2924823 H to I
13804: /* IF l_mo_type = INV_GLOBALS.G_MOVE_ORDER_MFG_PICK THEN */
13805: ELSIF l_mo_type IN (5,7)THEN -- wip picking bug 2924823 H to I
13806: UPDATE mtl_txn_request_lines
13807: SET quantity_detailed = quantity_delivered
13808: , line_status = 5
13809: WHERE line_id = l_mo_line_id;
13810:

Line 13849: UPDATE mtl_txn_request_lines

13845: RAISE fnd_api.g_exc_error;
13846: END IF;
13847: -- Bug 2924823 H to I
13848: if (l_wf <= 0) or (p_qty_rsn_id <= 0) then
13849: UPDATE mtl_txn_request_lines
13850: SET quantity_detailed = quantity_detailed - l_txn_qty,
13851: line_status = 5
13852: WHERE line_id = l_mo_line_id;
13853: end if;

Line 13855: UPDATE mtl_txn_request_lines

13851: line_status = 5
13852: WHERE line_id = l_mo_line_id;
13853: end if;
13854: ELSIF l_mo_type IN (INV_GLOBALS.G_MOVE_ORDER_REQUISITION, INV_GLOBALS.G_MOVE_ORDER_REPLENISHMENT) THEN
13855: UPDATE mtl_txn_request_lines
13856: SET quantity_detailed = quantity_delivered
13857: WHERE line_id = l_mo_line_id;
13858:
13859: inv_trx_util_pub.delete_transaction(

Line 13897: UPDATE mtl_txn_request_lines

13893: END IF;
13894:
13895: -- Bug 2924823 H to I
13896: if (l_wf <= 0) or (p_qty_rsn_id <= 0) then
13897: UPDATE mtl_txn_request_lines
13898: SET quantity_detailed = quantity_delivered
13899: WHERE line_id = l_mo_line_id;
13900: end if;
13901: END IF;

Line 14208: mtl_txn_request_lines mtrl, mtl_material_transactions_temp mmtt

14204:
14205: SELECT mtrh.move_order_type
14206: INTO l_mmtt_mo_type
14207: FROM mtl_txn_request_headers mtrh, -- mo header for the new task
14208: mtl_txn_request_lines mtrl, mtl_material_transactions_temp mmtt
14209: WHERE mtrh.header_id = mtrl.header_id
14210: AND mtrl.line_id = mmtt.move_order_line_id
14211: AND mmtt.transaction_temp_id = p_temp_id;
14212: