VIEW: APPS.FII_EFFECTIVE_DATES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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