VIEW: APPS.FII_SRS_ALL_TIME_PERIODS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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