APPS.INV_MO_CANCEL_PVT dependencies on MTL_TXN_REQUEST_LINES

Line 102: FROM mtl_txn_request_lines

98: , secondary_quantity
99: , NVL(secondary_quantity_detailed,0)
100: , organization_id
101: , txn_source_line_id
102: FROM mtl_txn_request_lines
103: WHERE line_id = p_line_id
104: FOR UPDATE NOWAIT;
105:
106: CURSOR c_reservations IS

Line 207: FROM mtl_txn_request_lines mtrl

203: -- {
204: BEGIN
205: SELECT NVL(mtrh.move_order_type,0)
206: INTO l_move_order_type
207: FROM mtl_txn_request_lines mtrl
208: , mtl_txn_request_headers mtrh
209: WHERE mtrl.line_id = p_line_id
210: AND mtrh.header_id = mtrl.header_id;
211:

Line 848: UPDATE mtl_txn_request_lines

844: END IF;
845:
846: -- Update line status, quantity, and required_quantity
847: -- INVCONV -Qty2
848: UPDATE mtl_txn_request_lines
849: SET quantity = l_quantity
850: , required_quantity = 0
851: , line_status = l_line_status
852: , secondary_quantity = l_sec_quantity

Line 931: update mtl_txn_request_lines

927: -- close the move order line.
928: --
929: IF (l_flag and l_count = l_count_alloc)
930: THEN
931: update mtl_txn_request_lines
932: set line_status = 5
933: , status_date =sysdate --BUG 6932648
934: where line_id = p_line_id;
935: END IF;

Line 951: FROM mtl_txn_request_lines mtrl

947: -- Lock the putaway move order line
948: BEGIN
949: SELECT 'x'
950: INTO l_dummy
951: FROM mtl_txn_request_lines mtrl
952: WHERE mtrl.line_id = p_line_id
953: FOR UPDATE NOWAIT;
954: EXCEPTION
955: WHEN record_locked THEN

Line 1254: FROM mtl_txn_request_lines

1250: , organization_id
1251: , inventory_item_id
1252: , uom_code
1253: , txn_source_line_id
1254: FROM mtl_txn_request_lines
1255: WHERE line_id = p_line_id
1256: FOR UPDATE;
1257:
1258: CURSOR c_primary_uom IS

Line 1361: FROM mtl_txn_request_lines mtrl

1357: --
1358: BEGIN
1359: SELECT NVL(mtrh.move_order_type,0)
1360: INTO l_move_order_type
1361: FROM mtl_txn_request_lines mtrl
1362: , mtl_txn_request_headers mtrh
1363: WHERE mtrl.line_id = p_line_id
1364: AND mtrh.header_id = mtrl.header_id;
1365:

Line 1774: UPDATE mtl_txn_request_lines

1770: 'l_required_quantity' and 'l_sec_required_quantity' respectively
1771: rather than with NULL. Also updation of 'quantity_detailed' is
1772: commented.*/
1773: --Bug 9212270: Do not update sec_qty_det
1774: UPDATE mtl_txn_request_lines
1775: SET quantity = l_quantity
1776: , required_quantity = l_required_quantity
1777: , secondary_quantity = l_sec_quantity --INVCONV
1778: , secondary_required_quantity = l_sec_required_quantity --INVCONV

Line 2307: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mtrl

2303: , l_reservation_id
2304: , l_organization_id
2305: , l_inventory_item_id
2306: , l_mo_uom_code
2307: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mtrl
2308: WHERE mmtt.transaction_temp_id = l_transaction_temp_id
2309: AND mmtt.move_order_line_id = mtrl.line_id;
2310:
2311: -- find quantity to delete in primary UOM

Line 2538: FROM mtl_txn_request_lines mtrl

2534: CURSOR c_get_mo_type
2535: ( p_mo_line_id IN NUMBER
2536: ) IS
2537: SELECT mtrh.move_order_type
2538: FROM mtl_txn_request_lines mtrl
2539: , mtl_txn_request_headers mtrh
2540: WHERE mtrl.line_id = p_mo_line_id
2541: AND mtrh.header_id = mtrl.header_id;
2542:

Line 2566: UPDATE mtl_txn_request_lines

2562: -- {{
2563: -- Unassign a pick released delivery detail from
2564: -- the delivery. Carton grouping ID must get updated }}
2565: --
2566: UPDATE mtl_txn_request_lines
2567: SET carton_grouping_id = p_carton_grouping_id
2568: WHERE line_id = p_line_id;
2569:
2570: -- {{