GL_FISCAL_DAY_V

Details

• Schema: FUSION

• Object owner: GL

• Object type: VIEW

Columns

Name

REPORT_DATE LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN PARENT_WEEK PARENT_MONTH DAY_OF_WEEK DAY_OF_MONTH DAY_OF_YEAR ENTERPRISE_ID FISCAL_PERIOD_SET_ID FISCAL_PERIOD_SET_NAME ADJUSTMENT_PERIOD_FLAG FISCAL_PERIOD_TYPE FISCAL_PERIOD_NAME FISCAL_PERIOD_NUMBER FISCAL_QUARTER_NUMBER FISCAL_YEAR_NUMBER FISCAL_PERIOD_START_DATE FISCAL_PERIOD_END_DATE FISCAL_QUARTER_START_DATE FISCAL_QUARTER_END_DATE FISCAL_YEAR_START_DATE FISCAL_YEAR_END_DATE FISCAL_PERIODSET_CREATION_DATE FISCAL_PERIOD_CREATION_DATE FISCAL_PERIOD_LAST_UPDATE_DATE

Query

SQL_Statement

SELECT D.REPORT_DATE, D.LAST_UPDATE_DATE, D.LAST_UPDATED_BY, D.CREATION_DATE, D.CREATED_BY, D.LAST_UPDATE_LOGIN, D.PARENT_WEEK, D.PARENT_MONTH, D.DAY_OF_WEEK, D.DAY_OF_MONTH, D.DAY_OF_YEAR, D.ENTERPRISE_ID, P.FISCAL_PERIOD_SET_ID, P.FISCAL_PERIOD_SET_NAME, P.ADJUSTMENT_PERIOD_FLAG, P.FISCAL_PERIOD_TYPE, P.FISCAL_PERIOD_NAME, P.FISCAL_PERIOD_NUMBER, P.FISCAL_QUARTER_NUMBER, P.FISCAL_YEAR_NUMBER, P.FISCAL_PERIOD_START_DATE, P.FISCAL_PERIOD_END_DATE, P.FISCAL_QUARTER_START_DATE, P.FISCAL_QUARTER_END_DATE, P.FISCAL_YEAR_START_DATE, P.FISCAL_YEAR_END_DATE, P.FISCAL_PERIODSET_CREATION_DATE, P.FISCAL_PERIOD_CREATION_DATE, P.FISCAL_PERIOD_LAST_UPDATE_DATE FROM FND_CAL_DAY D, Gl_FISCAL_PERIOD_V P WHERE D.REPORT_DATE BETWEEN P.FISCAL_PERIOD_START_DATE AND P.FISCAL_PERIOD_END_DATE