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_RESERVATION_UTIL dependencies on MTL_TXN_REQUEST_LINES

Line 1739: FROM mtl_txn_request_lines

1735: l_progress := '@@@';
1736: BEGIN
1737: SELECT 1
1738: INTO l_dummy
1739: FROM mtl_txn_request_lines
1740: WHERE line_id = p_cas_mol_rec_tb(1).line_id
1741: FOR UPDATE NOWAIT;
1742: EXCEPTION
1743: WHEN OTHERS THEN

Line 2154: FROM mtl_txn_request_lines mtrl

2150: -- to check if the LPN has available MOL quantity that has no wdd stamped
2151: BEGIN
2152: SELECT SUM(primary_quantity)
2153: INTO l_qty_with_no_wdd
2154: FROM mtl_txn_request_lines mtrl
2155: WHERE nvl(mtrl.lpn_id,-999)=nvl(p_cas_mol_rec_tb(1).lpn_id,-999)
2156: AND nvl(mtrl.from_subinventory_code,'&&&')=nvl(p_cas_mol_rec_tb(1).from_subinventory_code,'&&&')--???
2157: AND nvl(mtrl.from_locator_id,-999)=nvl(p_cas_mol_rec_tb(1).from_locator_id,-999)--???
2158: AND mtrl.organization_id = p_cas_mol_rec_tb(1).organization_id

Line 2231: FROM mtl_txn_request_lines mol

2227: AND mr.inventory_item_id = p_cas_mol_rec_tb(1).inventory_item_id
2228: AND ((mr.demand_source_line_detail IS NOT NULL
2229: AND mr.demand_source_line_detail
2230: IN (SELECT mol.backorder_delivery_detail_id
2231: FROM mtl_txn_request_lines mol
2232: WHERE mol.organization_id = p_cas_mol_rec_tb(1).organization_id
2233: AND mol.inventory_item_id = p_cas_mol_rec_tb(1).inventory_item_id
2234: AND NVL(mol.revision, '@@@') = NVL(p_cas_mol_rec_tb(1).item_revision, '@@@')
2235: AND (NVL(mol.project_id, -999) = NVL(p_cas_mol_rec_tb(1).project_id, -999)

Line 2252: FROM mtl_txn_request_lines mol

2248: AND mtrh.header_id = mol.header_id)
2249: )) OR
2250: (mr.demand_source_line_detail IS NULL
2251: AND exists (SELECT mol.backorder_delivery_detail_id
2252: FROM mtl_txn_request_lines mol
2253: WHERE mol.organization_id = p_cas_mol_rec_tb(1).organization_id
2254: AND mol.inventory_item_id = p_cas_mol_rec_tb(1).inventory_item_id
2255: AND NVL(mol.revision, '@@@') = NVL(p_cas_mol_rec_tb(1).item_revision, '@@@')
2256: AND (NVL(mol.project_id, -999) = NVL(p_cas_mol_rec_tb(1).project_id, -999)

Line 2289: FROM mtl_txn_request_lines mol

2285:
2286: BEGIN
2287: SELECT line_id
2288: INTO l_mo_line_id
2289: FROM mtl_txn_request_lines mol
2290: WHERE backorder_delivery_detail_id = l_rsv_results.demand_source_line_detail
2291: AND mol.organization_id = p_cas_mol_rec_tb(1).organization_id
2292: AND mol.inventory_item_id = p_cas_mol_rec_tb(1).inventory_item_id
2293: AND NVL(mol.revision, '@@@') = NVL(p_cas_mol_rec_tb(1).item_revision, '@@@')

Line 2470: UPDATE mtl_txn_request_lines

2466: l_tmp_line_id := l_mo_line_id;
2467: l_remaining_prim_qty := l_remaining_prim_qty - l_rsv_results.primary_reservation_quantity;
2468: END IF;
2469:
2470: UPDATE mtl_txn_request_lines
2471: SET quantity = Nvl(quantity_delivered,0)
2472: , primary_quantity = ((primary_quantity*Nvl(quantity_delivered,0))/quantity)
2473: , quantity_detailed = Decode(quantity_detailed,NULL,quantity_detailed,quantity_delivered)
2474: -- OPMConvergence

Line 2645: FROM mtl_txn_request_lines mtrl

2641: END IF;
2642:
2643: FOR l_mol_rec IN (SELECT mtrl.line_id
2644: , mtrl.primary_quantity
2645: FROM mtl_txn_request_lines mtrl
2646: WHERE mtrl.line_status = 7
2647: AND (mtrl.quantity-Nvl(mtrl.quantity_delivered,0)) > 0
2648: -- AND mtrl.backorder_delivery_detail_id IS NULL --Bug#6040524
2649: AND mtrl.organization_id = p_cas_mol_rec_tb(1).organization_id

Line 2726: UPDATE mtl_txn_request_lines

2722: IF (l_debug = 1) THEN
2723: print_debug('Closing MOL '||l_tmp_line_id,l_module_name,9);
2724: END IF;
2725:
2726: UPDATE mtl_txn_request_lines
2727: SET quantity = Nvl(quantity_delivered,0)
2728: , primary_quantity = ((primary_quantity*Nvl(quantity_delivered,0))/quantity)
2729: , quantity_detailed = Decode(quantity_detailed,NULL,quantity_detailed,quantity_delivered)
2730: -- OPMConvergence

Line 2813: FROM mtl_txn_request_lines mtrl

2809: , mmtt.wip_supply_type
2810: , mtrl.reference
2811: , mtrl.reference_type_code
2812: , mtrl.reference_id
2813: FROM mtl_txn_request_lines mtrl
2814: , mtl_material_transactions_temp mmtt
2815: WHERE mtrl.organization_id = p_org_id
2816: AND nvl(mtrl.from_subinventory_code,'@$#_') = nvl(p_from_sub,'@$#_')
2817: AND nvl(mtrl.from_locator_id,-1) = nvl(p_from_locator_id,-1)

Line 2949: UPDATE mtl_txn_request_lines

2945: p_cas_mol_tb(1).primary_uom_code);
2946:
2947: IF l_mol_qty_in_puom <= l_remaining_primary_quantity THEN
2948: --update the mol
2949: UPDATE mtl_txn_request_lines
2950: SET quantity = Nvl(quantity_delivered,0)
2951: , primary_quantity = ((primary_quantity*Nvl(quantity_delivered,0))/quantity)
2952: , quantity_detailed = Decode(quantity_detailed,NULL,quantity_detailed,quantity_delivered)
2953: -- OPMConvergence

Line 3015: UPDATE mtl_txn_request_lines

3011: print_debug('NEW LINE ID:'||l_mo_split_tb(1).line_id,l_module_name,4);
3012: END IF;
3013:
3014: --update the new line for return
3015: UPDATE mtl_txn_request_lines
3016: SET quantity = Nvl(quantity_delivered,0)
3017: , primary_quantity = ((primary_quantity*Nvl(quantity_delivered,0))/quantity)
3018: , quantity_detailed = Decode(quantity_detailed,NULL,quantity_detailed,quantity_delivered)
3019: -- OPMConvergence

Line 3047: UPDATE mtl_txn_request_lines

3043: RAISE fnd_api.g_exc_error;
3044: END IF;
3045:
3046: --update the old line for wms process flag
3047: UPDATE mtl_txn_request_lines
3048: SET wms_process_flag = 1
3049: WHERE line_id = l_mol_rec.line_id;
3050:
3051: l_remaining_primary_quantity := 0;