
Query to get the fiscal year name
SELECT
CALENDAR_TYPE,
DESCRIPTION,
PERIOD_SUFFIX_TYPE,
NUMBER_PER_FISCAL_YEAR,
FISCAL_YEAR_NAME
FROM
FA_CALENDAR_TYPES
WHERE
CALENDAR_TYPE='&calendertype';

SELECT
CALENDAR_TYPE,
DESCRIPTION,
PERIOD_SUFFIX_TYPE,
NUMBER_PER_FISCAL_YEAR,
FISCAL_YEAR_NAME
FROM
FA_CALENDAR_TYPES
WHERE
CALENDAR_TYPE='&calendertype';
No comments:
Post a Comment