SELECT F.SET_OF_BOOKS_FK_KEY , F.OPERATING_UNIT_FK_KEY , F.CUSTOMER_FK_KEY , F.FUNCTIONAL_CURRENCY , F.AMT_INVOICED_AR_G , F.INV_CREATED_CNT FROM (SELECT FII_TIME_WH_API.ENT_CYCQ_START CYCQ_START , FII_TIME_WH_API.TODAY CYCQ_TODAY FROM DUAL) CAL , FII_AR_OPER_CUST_SUMMARY_F F WHERE F.CALENDAR_DATE BETWEEN CAL.CYCQ_START AND CAL.CYCQ_TODAY AND (F.AMT_INVOICED_AR_G <> 0 OR F.INV_CREATED_CNT <> 0)