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.INV_RCV_INTEGRATION_PVT dependencies on MTL_TXN_REQUEST_LINES

Line 281: FROM mtl_txn_request_lines mtrl

277: SELECT '1'
278: INTO l_dummy
279: FROM dual
280: WHERE exists (SELECT '1'
281: FROM mtl_txn_request_lines mtrl
282: WHERE mtrl.lpn_id = p_lpn_id
283: AND mtrl.organization_id = p_org_id
284: AND (Nvl(mtrl.project_id,-1) <> Nvl(p_project_id,-1)
285: OR Nvl(mtrl.task_id,-1) <> Nvl(p_task_id,-1))

Line 3919: FROM mtl_txn_request_lines mtrl

3915: , mtrl.reference_id
3916: , mtrl.quantity txn_qty
3917: , mtrl.quantity_detailed quantity_detailed
3918: , mtrl.quantity_delivered quantity_delivered
3919: FROM mtl_txn_request_lines mtrl
3920: , mtl_material_transactions_temp mmtt
3921: WHERE mtrl.organization_id = p_org_id
3922: AND nvl(mtrl.from_subinventory_code,'@$#_') = nvl(p_from_sub,'@$#_')
3923: AND nvl(mtrl.from_locator_id,-1) = nvl(p_from_locator_id,-1)

Line 3992: FROM mtl_txn_request_lines mtrl

3988: , mtrl.reference_id
3989: , mtrl.quantity txn_qty
3990: , mtrl.quantity_detailed quantity_detailed
3991: , mtrl.quantity_delivered quantity_delivered
3992: FROM mtl_txn_request_lines mtrl
3993: , mtl_material_transactions_temp mmtt
3994: WHERE mtrl.organization_id = p_org_id
3995: AND nvl(mtrl.from_subinventory_code,'@$#_') = nvl(p_from_sub,'@$#_')
3996: AND nvl(mtrl.from_locator_id,-1) = nvl(p_from_locator_id,-1)

Line 4046: FROM mtl_txn_request_lines mtrl

4042: ,2) quantity_ordering
4043: ,mtrl.reference reference
4044: ,mtrl.reference_type_code reference_type_code
4045: ,mtrl.reference_id reference_id
4046: FROM mtl_txn_request_lines mtrl
4047: WHERE mtrl.organization_id = p_org_id
4048: AND mtrl.inventory_item_id = p_item
4049: AND mtrl.uom_code = p_uom_code
4050: AND Nvl(mtrl.revision, Nvl(p_rev, '@@@')) = Nvl(p_rev, '@@@')

Line 5068: update mtl_txn_request_lines

5064:
5065: --
5066: -- UPDATE THE MOVE ORDER LINE HERE
5067: --
5068: update mtl_txn_request_lines
5069: set reference = l_reference
5070: ,reference_type_code = l_reference_type_code
5071: ,reference_id = l_reference_id
5072: ,quantity = quantity + l_mol_res_out(l_loop_index).quantity

Line 5195: UPDATE mtl_txn_request_lines

5191: --update mol for the sub and loc
5192: --{{
5193: --Receive into a RCV sub/loc. Check MOL has these columns
5194: --stamped afterwards}}
5195: UPDATE mtl_txn_request_lines
5196: SET from_subinventory_code = Nvl(p_subinventory,from_subinventory_code)
5197: , from_locator_id = Nvl(p_locator_id, from_locator_id)
5198: , backorder_delivery_detail_id = l_mol_res_out(l_loop_index).backorder_delivery_detail_id
5199: , crossdock_type = l_mol_res_out(l_loop_index).crossdock_type

Line 5554: UPDATE mtl_txn_request_lines

5550: ELSE
5551: FETCH c_mol_no_mmtt INTO l_mol_rec;
5552: EXIT WHEN c_mol_no_mmtt%notfound;
5553: END IF;
5554: UPDATE mtl_txn_request_lines
5555: SET wms_process_flag = 1
5556: WHERE line_id = l_mol_rec.line_id;
5557: END LOOP;
5558:

Line 5708: UPDATE mtl_txn_request_lines

5704: print_debug('MAINTAIN_MO_CON - l_tmp_qty_dlvd:'||l_tmp_qty_dlvd,4);
5705: print_debug('MAINTAIN_MO_CON - l_tmp_uom_code:'||l_tmp_uom_code,4);
5706: END IF;
5707:
5708: UPDATE mtl_txn_request_lines
5709: SET inspection_status = Decode(l_transaction_type,'ACCEPT',2,'REJECT',3,inspection_status)
5710: , lpn_id = p_transfer_lpn_id
5711: , quantity = l_tmp_qty
5712: , quantity_detailed = Decode(l_transaction_type,'TRANSFER',l_tmp_qty_dtld,NULL)

Line 5746: UPDATE mtl_txn_request_lines

5742: IF (l_debug = 1) THEN
5743: print_debug('MAINTAIN_MO_CON - before updating mol update or close = C ',1);
5744: END IF;
5745:
5746: UPDATE mtl_txn_request_lines
5747: SET line_status = inv_globals.G_TO_STATUS_CLOSED
5748: , quantity = Nvl(quantity_delivered,0)
5749: , quantity_detailed = quantity_delivered
5750: , secondary_quantity_detailed = SECONDARY_QUANTITY_DELIVERED

Line 5802: UPDATE mtl_txn_request_lines

5798: IF (l_debug = 1) THEN
5799: print_debug('MAINTAIN_MO_CON - before updating mol update or clode <> C ',1);
5800: END IF;
5801:
5802: UPDATE mtl_txn_request_lines
5803: SET inspection_status = Decode(l_transaction_type,'ACCEPT',2,'REJECT',3,inspection_status)
5804: , lpn_id = p_transfer_lpn_id
5805: , quantity = l_tmp_qty
5806: , quantity_detailed = Decode(l_transaction_type,'TRANSFER',l_tmp_qty_dtld,NULL)

Line 5937: from MTL_TXN_REQUEST_LINES mtrl

5933: into l_backorder_delivery_detail_id
5934: ,l_split_qty
5935: ,l_split_sec_qty
5936: ,l_uom_code -- bug8283511
5937: from MTL_TXN_REQUEST_LINES mtrl
5938: where mtrl.line_id = l_mo_split_tb(1).line_id;
5939:
5940: l_progress := 'WMSINB-45115';
5941: IF (l_debug = 1) THEN

Line 5996: UPDATE mtl_txn_request_lines

5992:
5993: --Update quantity with the quantity converted to the UOM in the RTI. This is changed so
5994: --that the we honor the UOM entered by the user during
5995: --Transfer
5996: UPDATE mtl_txn_request_lines
5997: SET inspection_status = Decode(l_transaction_type,'ACCEPT',2,'REJECT',3,inspection_status)
5998: , lpn_id = p_transfer_lpn_id
5999: , quantity = Decode(uom_code
6000: ,p_uom_code

Line 6050: UPDATE mtl_txn_request_lines

6046: --same consolidation criteria. Otherwise it should be
6047: --updated just like the crossdock mols.
6048:
6049: IF (l_update_or_close = 'C') THEN
6050: UPDATE mtl_txn_request_lines
6051: SET line_status = inv_globals.G_TO_STATUS_CLOSED
6052: , quantity = quantity_delivered
6053: , quantity_detailed = quantity_delivered
6054: , secondary_quantity_detailed = SECONDARY_QUANTITY_DELIVERED

Line 6060: UPDATE mtl_txn_request_lines

6056: , backorder_delivery_detail_id = l_backorder_delivery_detail_id
6057: , crossdock_type = Decode(l_backorder_delivery_detail_id,NULL,NULL,crossdock_type)
6058: WHERE line_id = l_mo_split_tb(1).line_id;
6059: ELSE
6060: UPDATE mtl_txn_request_lines
6061: SET inspection_status = Decode(l_transaction_type,'ACCEPT',2,'REJECT',3,inspection_status)
6062: , lpn_id = p_transfer_lpn_id
6063: , quantity = Decode(p_uom_code,p_primary_uom_code,primary_quantity,uom_code--bug 13484877
6064: --commenting for bug 13484877,p_uom_code

Line 6114: --UPDATE mtl_txn_request_lines

6110: * to update the wms_process_flag MOL with 4 the first time
6111: * time you reach here. You should only update it when the
6112: * qty being processing match the MOL qty (which will done
6113: * when maintain_mo_con is called with qty 1 */
6114: --UPDATE mtl_txn_request_lines
6115: --SET wms_process_flag = 1
6116: --WHERE line_id = l_mol_rec.line_id;
6117:
6118: l_remaining_primary_quantity := 0;

Line 6277: update mtl_txn_request_lines

6273: ELSE
6274: l_qty_detailed := 0;
6275: END IF;
6276:
6277: update mtl_txn_request_lines
6278: set reference = l_reference
6279: ,reference_type_code = l_reference_type_code
6280: ,reference_id = l_reference_id
6281: ,quantity = quantity + l_mol_res_in(1).quantity

Line 6364: -- UPDATE mtl_txn_request_lines

6360: -- RAISE fnd_api.g_exc_error;
6361: -- END IF;
6362: --
6363: -- --update mol for the sub and loc
6364: -- UPDATE mtl_txn_request_lines
6365: -- SET from_subinventory_code = Nvl(p_subinventory,from_subinventory_code)
6366: -- , from_locator_id = Nvl(p_locator_id, from_locator_id)
6367: -- WHERE header_id = l_move_order_header_id
6368: -- and organization_id = p_org_id

Line 6750: UPDATE mtl_txn_request_lines

6746: l_progress := 'WMSINB-45053';
6747:
6748:
6749: --Close line
6750: UPDATE mtl_txn_request_lines
6751: SET quantity_delivered = Decode(p_mmtt_temp_id,NULL,
6752: Nvl(quantity_delivered,0)+l_quantity_delivered,quantity_delivered)
6753: ,secondary_quantity_delivered = Decode(p_mmtt_temp_id,NULL,
6754: Nvl(secondary_quantity_delivered,0)+l_sec_quantity_delivered,quantity_delivered)

Line 6823: UPDATE mtl_txn_request_lines

6819: END IF;
6820:
6821: l_progress := 'WMSINB-45053';
6822:
6823: UPDATE mtl_txn_request_lines
6824: SET quantity_delivered = Decode(p_mmtt_temp_id,NULL,quantity,quantity_delivered)
6825: -- OPMConvergence
6826: , secondary_quantity_delivered = Decode(p_mmtt_temp_id,NULL,secondary_quantity,secondary_quantity_delivered)
6827: -- OPMConvergence

Line 6925: UPDATE mtl_txn_request_lines

6921:
6922: IF (l_transaction_type = 'CORRECT') THEN
6923: --We need to update the wms_process_flag on mol for all the lines for the given lpn as
6924: --we update all the mols for the given lpn to 2 in mark_returns
6925: UPDATE mtl_txn_request_lines
6926: SET wms_process_flag = 1
6927: WHERE (lpn_id = p_lpn_id
6928: OR lpn_id = p_transfer_lpn_id);
6929: END IF;

Line 7310: update mtl_txn_request_lines

7306:
7307: --
7308: -- UPDATE THE MOVE ORDER LINE HERE
7309: --
7310: update mtl_txn_request_lines
7311: set reference = l_reference
7312: ,reference_type_code = l_reference_type_code
7313: ,reference_id = l_reference_id
7314: ,quantity = quantity + ABS(l_mol_res_out(l_loop_index).quantity)

Line 7428: UPDATE mtl_txn_request_lines

7424: RAISE fnd_api.g_exc_error;
7425: END IF;
7426:
7427: --update mol for the sub and loc
7428: UPDATE mtl_txn_request_lines
7429: SET from_subinventory_code = Nvl(l_transfer_sub,from_subinventory_code)
7430: , from_locator_id = Nvl(l_transfer_locator_id, from_locator_id)
7431: WHERE header_id = l_move_order_header_id
7432: and line_id = l_move_order_line_id

Line 7467: UPDATE mtl_txn_request_lines

7463:
7464: --We need to update the wms_process_flag on mol for all the lines for the given lpn as
7465: --we update all the mols for the given lpn to 2 in mark_returns
7466:
7467: UPDATE mtl_txn_request_lines
7468: SET wms_process_flag = 1
7469: WHERE (lpn_id = p_lpn_id
7470: OR lpn_id = p_transfer_lpn_id);
7471:

Line 7541: FROM wms_license_plate_numbers wlpn, mtl_txn_request_lines mtrl

7537: SELECT 'Y', mtrl.from_subinventory_code, mtrl.from_locator_id,
7538: mtrl.quantity
7539: INTO l_discrepancy_exist, l_mol_sub, l_mol_loc_id,
7540: l_mol_qty_in_puom
7541: FROM wms_license_plate_numbers wlpn, mtl_txn_request_lines mtrl
7542: WHERE wlpn.lpn_id = p_transfer_lpn_id
7543: AND wlpn.lpn_context = 3
7544: AND wlpn.organization_id = p_org_id
7545: AND wlpn.organization_id = mtrl.organization_id

Line 7597: UPDATE mtl_txn_request_lines

7593: should have been performed in the logic above. Note that this
7594: assumes that the UI have marked the correct MOL for processing
7595:
7596: --Update the wms_process_flag for all MOLs for the fiven lpns
7597: UPDATE mtl_txn_request_lines
7598: SET wms_process_flag = 1
7599: WHERE lpn_id = p_lpn_id;
7600:
7601: UPDATE mtl_txn_request_lines

Line 7601: UPDATE mtl_txn_request_lines

7597: UPDATE mtl_txn_request_lines
7598: SET wms_process_flag = 1
7599: WHERE lpn_id = p_lpn_id;
7600:
7601: UPDATE mtl_txn_request_lines
7602: SET wms_process_flag = 1
7603: WHERE lpn_id = p_transfer_lpn_id;
7604: */
7605: EXCEPTION

Line 11664: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mtrl

11660: , Nvl(mmtt.transaction_quantity,mtrl.quantity-Nvl(mtrl.quantity_delivered,0)) txn_qty
11661: , Nvl(mmtt.transaction_uom,mtrl.uom_code) txn_uom_code
11662: , Nvl(mmtt.secondary_transaction_quantity
11663: , mtrl.secondary_quantity-Nvl(mtrl.secondary_quantity_delivered,0)) sec_qty --OPM Convergence
11664: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mtrl
11665: WHERE mmtt.move_order_line_id (+)= mtrl.line_id
11666: AND mtrl.lpn_id = v_lpn_id
11667: AND mtrl.line_status = 7
11668: AND mtrl.quantity-Nvl(mtrl.quantity_delivered,0) > 0

Line 14535: -- from mtl_txn_request_lines mol

14531: -- INSPECTED MATERIAL EXISTS IN FLPN FAIL THE TXN
14532: -- Begin
14533: -- select 1
14534: -- into l_insp_mat_exists
14535: -- from mtl_txn_request_lines mol
14536: -- where mol.lpn_id = l_lpn_rec.lpn_id
14537: -- and nvl(mol.inspection_status,2) = 1
14538: -- and rownum = 1;
14539: -- if l_insp_mat_exists = 1 then