# Rx Logix Documentation

Lookup Settings
    SELECT 'DLP_OWNER.' || VIEW_NAME as TABLE_NAME
    from SYS.ALL_VIEWS
    WHERE  VIEW_NAME LIKE 'VW_RX_%'
    and OWNER = 'DLP_OWNER'
    ;

Iterate and Copy
    @activity('LookupTableList').output.value

ForEach
    @pipeline().parameters.tableList

Copy Data Source
    SELECT * FROM @{item().TABLE_NAME}

Copy Data Sink Oracle Table
    @{replace(item().TABLE_NAME,'VW_RX_','')}

Copy Data Pre-copy Script
    TRUNCATE TABLE @{replace(item().TABLE_NAME,'VW_RX_','')} DROP STORAGE