PSC_COM_FISCAL_CALENDAR_V

Details

• Schema: FUSION

• Object owner: PSC_CC

• 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 AGENCY_ID PERIOD_START_DATE PERIOD_END_DATE ACCOUNTING_PERIOD

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.AGENCY_ID, P.PERIOD_START_DATE, P.PERIOD_END_DATE, P.ACCOUNTING_PERIOD FROM FND_CAL_DAY D, PSC_ERP_CALENDAR P WHERE D.REPORT_DATE BETWEEN P.PERIOD_START_DATE AND P.PERIOD_END_DATE