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 338: UPDATE mtl_txn_request_lines

334: END IF;
335:
336: /*Bug 1588529*/
337: IF (l_detail_rec_count <= 0 AND l_auto_pick_flag = 'N') THEN
338: UPDATE mtl_txn_request_lines
339: SET line_status = 5
340: WHERE line_id = l_trolin_tbl(1).line_id
341: AND NOT EXISTS (SELECT 1 FROM mtl_material_transactions_temp /*6120769Added NOT EXISTS condition*/
342: WHERE move_order_line_id = l_trolin_tbl(1).line_id

Line 421: UPDATE mtl_txn_request_lines

417: RAISE fnd_api.g_exc_error;
418: END IF;
419:
420: -- HW INVCONV - Update Qty2 fields
421: UPDATE mtl_txn_request_lines
422: SET quantity_detailed = quantity_detailed - l_mold_tbl_temp(l_index).transaction_quantity
423: , quantity_delivered = quantity_delivered - l_mold_tbl_temp(l_index).transaction_quantity
424: , 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)
425: , 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 429: UPDATE mtl_txn_request_lines

425: , 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)
426: WHERE line_id = l_mold_tbl_temp(l_index).move_order_line_id;
427: END LOOP;
428:
429: UPDATE mtl_txn_request_lines
430: SET line_status = 7
431: WHERE line_id = p_line_id;
432:
433: COMMIT;

Line 618: FROM mtl_txn_request_lines

614: /* IF (p_move_order_type <> 3) THEN
615: -- HW INVCONV -Added Qty2
616: SELECT quantity_delivered, secondary_quantity_delivered
617: INTO l_detailed_qty, l_detailed_qty2
618: FROM mtl_txn_request_lines
619: WHERE line_id = p_line_id;
620:
621: IF l_detailed_qty IS NULL THEN
622: l_detailed_qty := 0;

Line 808: FROM mtl_txn_request_lines

804: SELECT project_id
805: , task_id
806: INTO l_project_id
807: , l_task_id
808: FROM mtl_txn_request_lines
809: WHERE line_id = (SELECT move_order_line_id
810: FROM mtl_material_transactions_temp
811: WHERE transaction_temp_id = p_transaction_temp_id);
812: END IF;

Line 1732: FROM mtl_txn_request_lines

1728: l_quantity_table number_table_type;
1729:
1730: CURSOR c_txn_source IS
1731: SELECT txn_source_line_id, inventory_item_id
1732: FROM mtl_txn_request_lines
1733: WHERE line_id = p_line_id;
1734:
1735: CURSOR c_source_line IS
1736: SELECT source_line_id, inventory_item_id

Line 1742: FROM mtl_txn_request_lines

1738: WHERE move_order_line_id = p_line_id;
1739:
1740: CURSOR c_mtrl_line_set IS
1741: SELECT quantity
1742: FROM mtl_txn_request_lines
1743: WHERE inventory_item_id = l_inventory_item_id
1744: AND line_status <> 5
1745: AND txn_source_line_id IN(SELECT line_id
1746: FROM oe_order_lines_all

Line 1752: FROM mtl_txn_request_lines

1748: FOR UPDATE OF quantity NOWAIT;
1749:
1750: CURSOR c_mtrl_line IS
1751: SELECT quantity
1752: FROM mtl_txn_request_lines
1753: WHERE inventory_item_id = l_inventory_item_id
1754: AND organization_id = l_organization_id --bug 7012974 performance issue in TMO
1755: AND line_status <> 5
1756: AND txn_source_line_id = l_txn_source_line_id

Line 1768: FROM mtl_txn_request_lines

1764:
1765: BEGIN
1766: SELECT organization_id
1767: INTO l_organization_id
1768: FROM mtl_txn_request_lines
1769: WHERE line_id = p_line_id;
1770: EXCEPTION
1771: WHEN NO_DATA_FOUND THEN
1772: RAISE fnd_api.g_exc_unexpected_error;

Line 1784: FROM mtl_txn_request_lines

1780: END IF;
1781:
1782: SELECT NVL(required_quantity, quantity), NVL(quantity_delivered, 0)
1783: INTO l_mo_quantity, l_quantity_delivered
1784: FROM mtl_txn_request_lines
1785: WHERE line_id = p_line_id;
1786:
1787: l_max_quantity := l_mo_quantity - l_quantity_delivered;
1788:

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

1951: SELECT mmtt.organization_id
1952: , mtrh.move_order_type
1953: INTO l_org_id
1954: , l_move_order_type
1955: FROM mtl_txn_request_headers mtrh, mtl_txn_request_lines mtrl, mtl_material_transactions_temp mmtt
1956: WHERE mmtt.move_order_line_id = mtrl.line_id
1957: AND mtrl.header_id = mtrh.header_id
1958: AND mmtt.transaction_temp_id = p_transaction_temp_id;
1959:

Line 2431: /* UPDATE mtl_txn_request_lines

2427: --Commenting out the update statement below as it was causing the
2428: --quantity_detailed in MOL to be wrongly updated with the current MMTT qty
2429: --Updates to MOL quantity_detailed should be done after updating MMTT.
2430: --Update QUANTITY_DETAILED in MTRL
2431: /* UPDATE mtl_txn_request_lines
2432: SET quantity_detailed = l_this_alloc + p_overpicked_qty
2433: WHERE line_id = l_mo_line_id;
2434: */
2435:

Line 2732: /* UPDATE mtl_txn_request_lines

2728: --Commenting out the update statement below as it was causing the
2729: --quantity_detailed in MOL to be wrongly updated with the current MMTT qty
2730: --Updates to MOL quantity_detailed should be done after updating MMTT.
2731: --Update QUANTITY_DETAILED in MTRL
2732: /* UPDATE mtl_txn_request_lines
2733: SET quantity_detailed = l_this_alloc + p_overpicked_qty
2734: WHERE line_id = l_mo_line_id;
2735: */
2736:

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

2833: SELECT mmtt.organization_id
2834: , mtrh.move_order_type
2835: INTO l_org_id
2836: , l_move_order_type
2837: FROM mtl_txn_request_headers mtrh, mtl_txn_request_lines mtrl, mtl_material_transactions_temp mmtt
2838: WHERE mmtt.move_order_line_id = mtrl.line_id
2839: AND mtrl.header_id = mtrh.header_id
2840: AND mmtt.transaction_temp_id = p_transaction_temp_id;
2841:

Line 3274: /* UPDATE mtl_txn_request_lines

3270: --Commenting out the update statement below as it was causing the
3271: --quantity_detailed in MOL to be wrongly updated with the current MMTT qty
3272: --Updates to MOL quantity_detailed should be done after updating MMTT.
3273: --Update QUANTITY_DETAILED in MTRL
3274: /* UPDATE mtl_txn_request_lines
3275: SET quantity_detailed = l_this_alloc + p_overpicked_qty
3276: WHERE line_id = l_mo_line_id;
3277: */
3278: