APPS.WMS_TXNRSN_ACTIONS_PUB dependencies on MTL_TXN_REQUEST_LINES

Line 139: FROM mtl_txn_request_lines

135:
136: -- Get UOM from MO Line which is the same as transaction_uom in MMTT
137: SELECT uom_code
138: INTO l_trans_uom
139: FROM mtl_txn_request_lines
140: WHERE line_id = l_line_num;
141: IF (l_debug = 1) THEN
142: mdebug('uom_code '|| l_trans_uom);
143: END IF;

Line 158: UPDATE mtl_txn_request_lines

154:
155: IF (l_debug = 1) THEN
156: mdebug('before update mo line');
157: END IF;
158: UPDATE mtl_txn_request_lines
159: SET quantity_detailed = quantity_detailed-l_qty_diff_txn
160: WHERE line_id = l_line_num;
161:
162: IF (l_debug = 1) THEN

Line 389: l_test mtl_txn_request_lines%ROWTYPE;

385: l_order_count NUMBER := 1; /* total number of lines */
386:
387: l_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
388: l_trolin_rec INV_Move_Order_PUB.trolin_rec_type;
389: l_test mtl_txn_request_lines%ROWTYPE;
390:
391: l_det_cnt NUMBER;
392: l_next_task_id NUMBER;
393: l_print_mode VARCHAR2(1):='E';

Line 1499: FROM mtl_txn_request_lines

1495: , l_old_sec_qty_detailed
1496: , l_line_status
1497: , l_quantity_delivered
1498: , l_sec_qty_delivered
1499: FROM mtl_txn_request_lines
1500: WHERE line_id = l_line_num;
1501:
1502: mdebug('l_quantity_delivered:'||l_quantity_delivered);
1503: mdebug('l_sec_qty_delivered:'||l_sec_qty_delivered);

Line 1686: UPDATE mtl_txn_request_lines

1682: mdebug('In J patchset update move order line');
1683: -- bug 8197499 starts
1684: IF (l_sec_uom_code IS NOT NULL) THEN
1685: mdebug('l_sec_uom_code IS NOT NULL ' );
1686: UPDATE mtl_txn_request_lines
1687: SET quantity_detailed = l_new_quantity_detailed
1688: , secondary_quantity_detailed = l_new_sec_qty_detailed
1689: , last_update_date = SYSDATE
1690: , last_updated_by = l_user_id

Line 1694: UPDATE mtl_txn_request_lines

1690: , last_updated_by = l_user_id
1691: WHERE organization_id = l_organization_id
1692: AND line_id = l_line_num;
1693: ELSE --bug 8197499 ends
1694: UPDATE mtl_txn_request_lines
1695: SET quantity_detailed = quantity_detailed - l_mol_delta_qty
1696: , last_update_date = SYSDATE
1697: , last_updated_by = l_user_id
1698: WHERE organization_id = l_organization_id

Line 1704: UPDATE mtl_txn_request_lines

1700: END IF;
1701: ELSE
1702: -- 11.5.9 or lower, so no secondary qty update required
1703: -- fix for bug 3278170
1704: UPDATE mtl_txn_request_lines
1705: SET quantity_detailed = (NVL(quantity_detailed,0) - NVL(l_quantity_delivered,0)) - l_mol_delta_qty --bug3278170
1706: , last_update_date = SYSDATE
1707: , last_updated_by = l_user_id
1708: , quantity_delivered = 0 --bug3278170

Line 1757: from mtl_txn_request_lines

1753: select quantity_detailed,
1754: to_account_id --BUG#3048061
1755: into l_new_quantity_detailed, -- added for bug 9895550
1756: l_to_account_id --BUG#3048061
1757: from mtl_txn_request_lines
1758: where line_id = l_line_num;
1759:
1760: mdebug('after update mol, the quantity_detailed :' || l_new_quantity_detailed); -- added for bug 9895550
1761:

Line 1832: UPDATE mtl_txn_request_lines

1828: from_name => null,
1829: to_name => null);
1830: END IF;
1831:
1832: UPDATE mtl_txn_request_lines
1833: SET quantity_detailed = l_detailed_qty + l_quantity_delivered
1834: , secondary_quantity_detailed = DECODE(secondary_uom_code,NULL,NULL,
1835: l_sec_detailed_qty + l_sec_qty_delivered) -- Bug 8312574
1836: WHERE line_id = l_line_num

Line 1841: -- from to_account_id of mtl_txn_request_lines

1837: AND organization_id = l_organization_id;
1838:
1839: -- Bug#3048061
1840: -- Update the distribution_account_id of MMTT
1841: -- from to_account_id of mtl_txn_request_lines
1842: -- Since, MOs allocated using MO Pick Slip Report too,
1843: -- along with manually allocated MO will populate
1844: -- the distribution_account_id of MMTT.
1845:

Line 1863: UPDATE mtl_txn_request_lines

1859: INTO l_new_mmtt_qty
1860: FROM mtl_material_transactions_temp
1861: WHERE move_order_line_id = l_line_num;
1862:
1863: UPDATE mtl_txn_request_lines
1864: SET quantity = nvl(l_new_mmtt_qty,0) + l_quantity_delivered ,
1865: quantity_detailed = nvl(l_new_mmtt_qty,0) + l_quantity_delivered ,
1866: quantity_delivered = l_quantity_delivered
1867: WHERE organization_id = l_organization_id

Line 2366: FROM mtl_txn_request_headers mtrh, mtl_txn_request_lines mtrl

2362: , mtrl.quantity_delivered
2363: , mtrl.primary_quantity
2364: , mtrl.secondary_quantity
2365: , mtrl.secondary_uom_code
2366: FROM mtl_txn_request_headers mtrh, mtl_txn_request_lines mtrl
2367: WHERE mtrl.line_id = l_mo_line_id
2368: AND mtrh.header_id = mtrl.header_id;
2369:
2370: CURSOR c_get_other_mmtt IS

Line 2747: UPDATE mtl_txn_request_lines

2743: l_progress := '300';
2744: IF (l_debug = 1) THEN
2745: mdebug ('l_progress: ' || l_progress );
2746: END IF;
2747: UPDATE mtl_txn_request_lines
2748: SET quantity_detailed = quantity_detailed - l_txn_qty
2749: , secondary_quantity_detailed = DECODE(secondary_uom_code,NULL,NULL,
2750: secondary_quantity_detailed - l_sec_txn_qty) -- Bug 8312574
2751: , last_update_date = SYSDATE

Line 2795: UPDATE mtl_txn_request_lines

2791:
2792: ELSIF l_mo_type IN (INV_GLOBALS.G_MOVE_ORDER_REQUISITION, INV_GLOBALS.G_MOVE_ORDER_REPLENISHMENT) THEN
2793: l_progress := '370';
2794: IF (l_debug = 1) THEN mdebug ('l_progress: ' || l_progress ); END IF;
2795: UPDATE mtl_txn_request_lines
2796: SET quantity_detailed = quantity_delivered
2797: , secondary_quantity_detailed =
2798: DECODE(secondary_uom_code,NULL,NULL,secondary_quantity_delivered) -- Bug 8312574
2799: , last_update_date = SYSDATE

Line 2846: UPDATE mtl_txn_request_lines

2842:
2843: l_progress := '380';
2844: IF (l_debug = 1) THEN mdebug ('l_progress: ' || l_progress ); END IF;
2845: IF (l_wf <= 0) or (p_qty_rsn_id <= 0) then
2846: UPDATE mtl_txn_request_lines
2847: SET quantity_detailed = quantity_delivered
2848: , secondary_quantity_detailed =
2849: DECODE(secondary_uom_code,NULL,NULL,secondary_quantity_delivered) -- Bug 8312574
2850: , last_update_date = SYSDATE