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

Line 369: UPDATE mtl_txn_request_lines

365: END IF;
366:
367: /*Bug 1588529*/
368: IF (l_detail_rec_count <= 0 AND l_auto_pick_flag = 'N') THEN
369: UPDATE mtl_txn_request_lines
370: SET line_status = 5
371: WHERE line_id = l_trolin_tbl(1).line_id
372: AND NOT EXISTS (SELECT 1 FROM mtl_material_transactions_temp /*6120769Added NOT EXISTS condition*/
373: WHERE move_order_line_id = l_trolin_tbl(1).line_id

Line 464: UPDATE mtl_txn_request_lines

460: RAISE fnd_api.g_exc_error;
461: END IF;
462:
463: -- HW INVCONV - Update Qty2 fields
464: UPDATE mtl_txn_request_lines
465: SET quantity_detailed = quantity_detailed - l_mold_tbl_temp(l_index).transaction_quantity
466: , quantity_delivered = quantity_delivered - l_mold_tbl_temp(l_index).transaction_quantity
467: , secondary_quantity_detailed = decode(secondary_quantity_detailed,FND_API.G_MISS_NUM, NULL, secondary_quantity_detailed - l_mold_tbl_temp(l_index).secondary_transaction_quantity)
468: , secondary_quantity_delivered =decode(secondary_quantity_delivered,FND_API.G_MISS_NUM, NULL, secondary_quantity_delivered - l_mold_tbl_temp(l_index).secondary_transaction_quantity)

Line 472: UPDATE mtl_txn_request_lines

468: , secondary_quantity_delivered =decode(secondary_quantity_delivered,FND_API.G_MISS_NUM, NULL, secondary_quantity_delivered - l_mold_tbl_temp(l_index).secondary_transaction_quantity)
469: WHERE line_id = l_mold_tbl_temp(l_index).move_order_line_id;
470: END LOOP;
471:
472: UPDATE mtl_txn_request_lines
473: SET line_status = 7
474: WHERE line_id = p_line_id;
475:
476: COMMIT;

Line 661: FROM mtl_txn_request_lines

657: /* IF (p_move_order_type <> 3) THEN
658: -- HW INVCONV -Added Qty2
659: SELECT quantity_delivered, secondary_quantity_delivered
660: INTO l_detailed_qty, l_detailed_qty2
661: FROM mtl_txn_request_lines
662: WHERE line_id = p_line_id;
663:
664: IF l_detailed_qty IS NULL THEN
665: l_detailed_qty := 0;

Line 710: FROM mtl_txn_request_lines

706: END IF;
707:
708: -- MUOM Fulfillment Project latent issue
709: SELECT uom_code INTO l_detailed_uom
710: FROM mtl_txn_request_lines
711: WHERE line_id = p_line_id;
712:
713: IF l_txn_uom = l_detailed_uom THEN
714: l_detailed_qty := l_detailed_qty + ABS(l_transaction_quantity);

Line 935: FROM mtl_txn_request_lines

931: SELECT project_id
932: , task_id
933: INTO l_project_id
934: , l_task_id
935: FROM mtl_txn_request_lines
936: WHERE line_id = (SELECT move_order_line_id
937: FROM mtl_material_transactions_temp
938: WHERE transaction_temp_id = p_transaction_temp_id);
939: END IF;

Line 1874: FROM mtl_txn_request_lines

1870: l_quantity_table number_table_type;
1871:
1872: CURSOR c_txn_source IS
1873: SELECT txn_source_line_id, inventory_item_id, transaction_source_type_id
1874: FROM mtl_txn_request_lines
1875: WHERE line_id = p_line_id;
1876:
1877: CURSOR c_source_line IS
1878: SELECT source_line_id, inventory_item_id

Line 1884: FROM mtl_txn_request_lines

1880: WHERE move_order_line_id = p_line_id;
1881:
1882: CURSOR c_mtrl_line_set IS
1883: SELECT quantity
1884: FROM mtl_txn_request_lines
1885: WHERE inventory_item_id = l_inventory_item_id
1886: AND line_status <> 5
1887: AND txn_source_line_id IN(SELECT line_id
1888: FROM oe_order_lines_all

Line 1894: FROM mtl_txn_request_lines

1890: FOR UPDATE OF quantity NOWAIT;
1891:
1892: CURSOR c_mtrl_line IS
1893: SELECT quantity
1894: FROM mtl_txn_request_lines
1895: WHERE inventory_item_id = l_inventory_item_id
1896: AND organization_id = l_organization_id --bug 7012974 performance issue in TMO
1897: AND line_status <> 5
1898: AND txn_source_line_id = l_txn_source_line_id

Line 1910: FROM mtl_txn_request_lines

1906:
1907: BEGIN
1908: SELECT organization_id
1909: INTO l_organization_id
1910: FROM mtl_txn_request_lines
1911: WHERE line_id = p_line_id;
1912: EXCEPTION
1913: WHEN NO_DATA_FOUND THEN
1914: RAISE fnd_api.g_exc_unexpected_error;

Line 1961: FROM mtl_txn_request_lines

1957: END IF;
1958:
1959: SELECT NVL(required_quantity, quantity), NVL(quantity_delivered, 0) , NVL(secondary_required_quantity, secondary_quantity) ,NVL(secondary_quantity_delivered, 0)
1960: INTO l_mo_quantity, l_quantity_delivered, l_mo_quantity2, l_quantity_delivered2
1961: FROM mtl_txn_request_lines
1962: WHERE line_id = p_line_id;
1963:
1964: l_max_quantity := l_mo_quantity - l_quantity_delivered;
1965: l_max_quantity2 := l_mo_quantity2 - l_quantity_delivered2;

Line 2181: FROM mtl_txn_request_headers mtrh, mtl_txn_request_lines mtrl, mtl_material_transactions_temp mmtt

2177: SELECT mmtt.organization_id
2178: , mtrh.move_order_type
2179: INTO l_org_id
2180: , l_move_order_type
2181: FROM mtl_txn_request_headers mtrh, mtl_txn_request_lines mtrl, mtl_material_transactions_temp mmtt
2182: WHERE mmtt.move_order_line_id = mtrl.line_id
2183: AND mtrl.header_id = mtrh.header_id
2184: AND mmtt.transaction_temp_id = p_transaction_temp_id;
2185:

Line 2708: /* UPDATE mtl_txn_request_lines

2704: --Commenting out the update statement below as it was causing the
2705: --quantity_detailed in MOL to be wrongly updated with the current MMTT qty
2706: --Updates to MOL quantity_detailed should be done after updating MMTT.
2707: --Update QUANTITY_DETAILED in MTRL
2708: /* UPDATE mtl_txn_request_lines
2709: SET quantity_detailed = l_this_alloc + p_overpicked_qty
2710: WHERE line_id = l_mo_line_id;
2711: */
2712:

Line 3011: /* UPDATE mtl_txn_request_lines

3007: --Commenting out the update statement below as it was causing the
3008: --quantity_detailed in MOL to be wrongly updated with the current MMTT qty
3009: --Updates to MOL quantity_detailed should be done after updating MMTT.
3010: --Update QUANTITY_DETAILED in MTRL
3011: /* UPDATE mtl_txn_request_lines
3012: SET quantity_detailed = l_this_alloc + p_overpicked_qty
3013: WHERE line_id = l_mo_line_id;
3014: */
3015:

Line 3191: FROM mtl_txn_request_headers mtrh, mtl_txn_request_lines mtrl, mtl_material_transactions_temp mmtt

3187: SELECT mmtt.organization_id
3188: , mtrh.move_order_type
3189: INTO l_org_id
3190: , l_move_order_type
3191: FROM mtl_txn_request_headers mtrh, mtl_txn_request_lines mtrl, mtl_material_transactions_temp mmtt
3192: WHERE mmtt.move_order_line_id = mtrl.line_id
3193: AND mtrl.header_id = mtrh.header_id
3194: AND mmtt.transaction_temp_id = p_transaction_temp_id;
3195:

Line 3725: /* UPDATE mtl_txn_request_lines

3721: --Commenting out the update statement below as it was causing the
3722: --quantity_detailed in MOL to be wrongly updated with the current MMTT qty
3723: --Updates to MOL quantity_detailed should be done after updating MMTT.
3724: --Update QUANTITY_DETAILED in MTRL
3725: /* UPDATE mtl_txn_request_lines
3726: SET quantity_detailed = l_this_alloc + p_overpicked_qty
3727: WHERE line_id = l_mo_line_id;
3728: */
3729: