View: FII_SRS_ALL_TIME_PERIODS_V

Product:	FII - Financial Intelligence
Description:	View that supports time period LOV in FII integrator.
Implementation/DBA Data:	APPS.FII_SRS_ALL_TIME_PERIODS_V

View Text

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) )

Columns