DBA Data[Home] [Help]

APPS.AHL_OSP_RCV_PVT dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 2177: DELETE FROM MTL_TRANSACTION_LOTS_INTERFACE

2173:
2174: DELETE FROM MTL_SERIAL_NUMBERS_INTERFACE
2175: WHERE PRODUCT_TRANSACTION_ID = l_err_intf_trans_id;
2176:
2177: DELETE FROM MTL_TRANSACTION_LOTS_INTERFACE
2178: WHERE PRODUCT_TRANSACTION_ID = l_err_intf_trans_id;
2179:
2180: DELETE FROM RCV_TRANSACTIONS_INTERFACE
2181: WHERE INTERFACE_TRANSACTION_ID = l_err_intf_trans_id;

Line 2401: INSERT INTO MTL_TRANSACTION_LOTS_INTERFACE

2397: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'l_trans_lot_number:'||l_trans_lot_number);
2398: END IF;
2399:
2400: IF(l_trans_lot_number is not null) THEN
2401: INSERT INTO MTL_TRANSACTION_LOTS_INTERFACE
2402: (
2403: TRANSACTION_INTERFACE_ID,
2404: LAST_UPDATE_DATE,
2405: LAST_UPDATED_BY,