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 930: update mtl_txn_request_lines

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

Line 949: FROM mtl_txn_request_lines mtrl

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

Line 1252: FROM mtl_txn_request_lines

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

Line 1359: FROM mtl_txn_request_lines mtrl

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

Line 1789: UPDATE mtl_txn_request_lines

1785: 'l_required_quantity' and 'l_sec_required_quantity' respectively
1786: rather than with NULL. Also updation of 'quantity_detailed' is
1787: commented.*/
1788:
1789: UPDATE mtl_txn_request_lines
1790: SET quantity = l_quantity
1791: , required_quantity = l_required_quantity
1792: , secondary_quantity = l_sec_quantity --INVCONV
1793: , secondary_required_quantity = l_sec_required_quantity --INVCONV

Line 2322: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mtrl

2318: , l_reservation_id
2319: , l_organization_id
2320: , l_inventory_item_id
2321: , l_mo_uom_code
2322: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mtrl
2323: WHERE mmtt.transaction_temp_id = l_transaction_temp_id
2324: AND mmtt.move_order_line_id = mtrl.line_id;
2325:
2326: -- find quantity to delete in primary UOM

Line 2553: FROM mtl_txn_request_lines mtrl

2549: CURSOR c_get_mo_type
2550: ( p_mo_line_id IN NUMBER
2551: ) IS
2552: SELECT mtrh.move_order_type
2553: FROM mtl_txn_request_lines mtrl
2554: , mtl_txn_request_headers mtrh
2555: WHERE mtrl.line_id = p_mo_line_id
2556: AND mtrh.header_id = mtrl.header_id;
2557:

Line 2581: UPDATE mtl_txn_request_lines

2577: -- {{
2578: -- Unassign a pick released delivery detail from
2579: -- the delivery. Carton grouping ID must get updated }}
2580: --
2581: UPDATE mtl_txn_request_lines
2582: SET carton_grouping_id = p_carton_grouping_id
2583: WHERE line_id = p_line_id;
2584:
2585: -- {{