DBA Data[Home] [Help]

APPS.AHL_OSP_RCV_PVT dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 1900: DELETE FROM MTL_TRANSACTION_LOTS_INTERFACE

1896:
1897: DELETE FROM MTL_SERIAL_NUMBERS_INTERFACE
1898: WHERE PRODUCT_TRANSACTION_ID = l_err_intf_trans_id;
1899:
1900: DELETE FROM MTL_TRANSACTION_LOTS_INTERFACE
1901: WHERE PRODUCT_TRANSACTION_ID = l_err_intf_trans_id;
1902:
1903: DELETE FROM RCV_TRANSACTIONS_INTERFACE
1904: WHERE INTERFACE_TRANSACTION_ID = l_err_intf_trans_id;

Line 2122: INSERT INTO MTL_TRANSACTION_LOTS_INTERFACE

2118: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'l_trans_lot_number:'||l_trans_lot_number);
2119: END IF;
2120:
2121: IF(l_trans_lot_number is not null) THEN
2122: INSERT INTO MTL_TRANSACTION_LOTS_INTERFACE
2123: (
2124: TRANSACTION_INTERFACE_ID,
2125: LAST_UPDATE_DATE,
2126: LAST_UPDATED_BY,