SELECT NAME , TIME_ID , PERIOD_TYPE_ID , PERIOD FROM ( SELECT P.NAME NAME , P.ENT_PERIOD_ID TIME_ID , 32 PERIOD_TYPE_ID , 'P' PERIOD FROM FII_TIME_ENT_PERIOD P UNION SELECT Q.NAME NAME , Q.ENT_QTR_ID TIME_ID , 64 PERIOD_TYPE_ID , 'Q' PERIOD FROM FII_TIME_ENT_QTR Q UNION SELECT Y.NAME NAME , Y.ENT_YEAR_ID TIME_ID , 128 PERIOD_TYPE_ID , 'Y' PERIOD FROM FII_TIME_ENT_YEAR Y UNION SELECT LK.MEANING NAME , -1 TIME_ID , -1 PERIOD_TYPE_ID , 'N/A' PERIOD FROM FND_LOOKUP_VALUES LK WHERE LK.LOOKUP_TYPE = 'FII_LITERAL' AND LK.LOOKUP_CODE = 'N/A' AND LANGUAGE = USERENV('LANG') AND VIEW_APPLICATION_ID = 450 AND SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP(LOOKUP_TYPE , VIEW_APPLICATION_ID) )