View: FII_EFFECTIVE_DATES_V

Product:	FII - Financial Intelligence
Description:	View that supports Effective date LOV in FII integrator download screen.
Implementation/DBA Data:	APPS.FII_EFFECTIVE_DATES_V

View Text

SELECT VERSION_DATE
, MEANING
FROM ( SELECT NVL(TO_CHAR(VERSION_DATE
, 'DD-MM-YYYY')
, '01-01-2999') VERSION_DATE
, DECODE(VERSION_DATE
, NULL
, 'NULL'
, VERSION_DATE)||' - '||V.MEANING MEANING
FROM ( SELECT DISTINCT VERSION_DATE
, PLAN_TYPE_CODE
FROM FII_BUDGET_INTERFACE
WHERE STATUS_CODE = 'ERROR') A
, FND_LOOKUP_VALUES V
WHERE A.PLAN_TYPE_CODE = V.LOOKUP_CODE
AND V.LOOKUP_TYPE = 'FII_PLAN_TYPE'
AND V.SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP(V.LOOKUP_TYPE
, V.VIEW_APPLICATION_ID) UNION SELECT '01-01-2999' VERSION_DATE
, 'NULL' MEANING
FROM DUAL) ORDER BY VERSION_DATE

Columns