SELECT APP_SHORT_NAME , ORG_ID , NAME , SET_OF_BOOKS_ID , SET_OF_BOOKS_NAME , CURRENCY_CODE , DESCRIPTION FROM CE_FORECAST_AP_ORGS_V UNION ALL SELECT APP_SHORT_NAME , ORG_ID , NAME , SET_OF_BOOKS_ID , SET_OF_BOOKS_NAME , CURRENCY_CODE , DESCRIPTION FROM CE_FORECAST_PO_ORGS_V UNION ALL SELECT APP_SHORT_NAME , ORG_ID , NAME , SET_OF_BOOKS_ID , SET_OF_BOOKS_NAME , CURRENCY_CODE , DESCRIPTION FROM CE_FORECAST_PAY_ORGS_V UNION ALL SELECT APP_SHORT_NAME , ORG_ID , NAME , SET_OF_BOOKS_ID , SET_OF_BOOKS_NAME , CURRENCY_CODE , DESCRIPTION FROM CE_FORECAST_AR_ORGS_V UNION ALL SELECT APP_SHORT_NAME , ORG_ID , NAME , SET_OF_BOOKS_ID , SET_OF_BOOKS_NAME , CURRENCY_CODE , DESCRIPTION FROM CE_FORECAST_AS_ORGS_V UNION ALL SELECT APP_SHORT_NAME , ORG_ID , NAME , SET_OF_BOOKS_ID , SET_OF_BOOKS_NAME , CURRENCY_CODE , DESCRIPTION FROM CE_FORECAST_OE_ORGS_V UNION ALL SELECT NULL , TO_NUMBER(LOOKUP_CODE) , MEANING , TO_NUMBER(NULL) , NULL , NULL , NULL FROM CE_LOOKUPS WHERE LOOKUP_TYPE = 'FORECAST_ALL' UNION ALL SELECT APP_SHORT_NAME , ORG_ID , NAME , SET_OF_BOOKS_ID , SET_OF_BOOKS_NAME , CURRENCY_CODE , DESCRIPTION FROM CE_FORECAST_PA_ORGS_V