Untitled

INSERT INTO IASUPRT.mdm_prty_purge_data
(entrps_id, prty_rowid, actv_flg, comments, purge_process_ind, purge_pickup_indicator, create_ts)
SELECT 
    'EID',                     -- Static value for entrps_id
    prty_rowid,                -- Column from the source table
    'Y',                       -- Static value for actv_flg
    'PURGE_PROCESS_AUTOMATION',-- Static value for comments
    'N',                       -- Static value for purge_process_ind
    'N',                       -- Static value for purge_pickup_indicator
    CURRENT_TIMESTAMP          -- Current timestamp for create_ts
FROM 
    iaorsta.c_b_prty_entrps_id
WHERE 
    -- You can add any conditions here if needed
    1=1;  -- This is a placeholder. Replace with actual conditions if needed.