APPS.WMS_ENGINE_PVT dependencies on MTL_TXN_REQUEST_LINES

Line 1911: FROM mtl_txn_request_lines mtrl

1907: SELECT lpn_context
1908: INTO l_lpn_context
1909: FROM wms_license_plate_numbers wlpn
1910: WHERE lpn_id = (SELECT lpn_id
1911: FROM mtl_txn_request_lines mtrl
1912: WHERE mtrl.line_id = p_transaction_temp_id)
1913: AND EXISTS(SELECT 1 FROM wms_lpn_contents wlc, mtl_txn_request_lines mtrl -- for bug 14035958
1914: WHERE wlc.parent_lpn_id=mtrl.lpn_id
1915: AND mtrl.line_id = p_transaction_temp_id

Line 1913: AND EXISTS(SELECT 1 FROM wms_lpn_contents wlc, mtl_txn_request_lines mtrl -- for bug 14035958

1909: FROM wms_license_plate_numbers wlpn
1910: WHERE lpn_id = (SELECT lpn_id
1911: FROM mtl_txn_request_lines mtrl
1912: WHERE mtrl.line_id = p_transaction_temp_id)
1913: AND EXISTS(SELECT 1 FROM wms_lpn_contents wlc, mtl_txn_request_lines mtrl -- for bug 14035958
1914: WHERE wlc.parent_lpn_id=mtrl.lpn_id
1915: AND mtrl.line_id = p_transaction_temp_id
1916: AND wlc.parent_lpn_id=wlpn.lpn_id
1917: And wlc.inventory_item_id=mtrl.inventory_item_id

Line 1954: FROM mtl_txn_request_lines mtrl

1950: SELECT lpn_context
1951: INTO l_lpn_context
1952: FROM wms_license_plate_numbers
1953: WHERE lpn_id = l_request_line_rec.lpn_id ; /* (SELECT lpn_id
1954: FROM mtl_txn_request_lines mtrl
1955: WHERE mtrl.line_id = p_transaction_temp_id);*/
1956:
1957: IF l_lpn_context = 1 AND l_allow_nr_sub_xfer = 'Y' THEN
1958: l_quick_pick_flag := 'Q';

Line 2922: update mtl_txn_Request_lines mtrl

2918: NULL);
2919:
2920:
2921: if (abs(inv_cache.mol_rec.primary_quantity - l_mtrl_pri_qty) > 0.00005) then --BUG13591755
2922: update mtl_txn_Request_lines mtrl
2923: set primary_quantity = l_mtrl_pri_qty
2924: where line_id = p_transaction_temp_id
2925: and TRANSACTION_SOURCE_TYPE_ID in (1,7,12); -- only inbound mtrls
2926: end if;