Query to get the fiscal year name

Query to get the fiscal year name, AskHareesh blog for Oracle Apps

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';

*/

No comments:

Post a Comment