new update with materialize only
SELECT rules.RecordName, rules.RecordNumber, rules.PaysheetId_c, rules.PayPeriodID_c, rules.PayDate_c, rules.BadgeIDWorkerNumber_c, rules.ParticipantId_c, rules.RoleStartDate_c, rules.RoleEndDate_c, rules.PaymentBatch_c, rules.PayGroup_c, NVL(TO_CHAR(rules.TotalPaysheetAmount_c, 'FM9999999990.0000'), '0') AS TotalPaysheetAmount_c, rules.CurrencyCode, rules.PlanComponentId_c, NVL(TO_CHAR(rules.ProratedTI_c, 'FM9999999990.0000'), '0') AS ProratedTI_c, TO_CHAR(rules.PTDUSD_c) AS PTDUSD_c, TO_CHAR(rules.BBUSD_c) AS BBUSD_c, rules.MultiCurrency_c, rules.PaysheetAutomatedRefreshStartCST_c, rules.PaysheetAutomatedRefreshEndCST_c, TO_CHAR(rules.TotalPaysheetAmountUSD_c) AS TotalPaysheetAmountUSD_c, rules.ConversionRateHomeToUSD_c, rules.PlanComponentName_c, rules.OwnerEmailId_c, rules.HRStatus_c, rules.EmploymentCountry_c, rules.RoleName_c, NVL(TO_CHAR(ru...