DBA Data[Home] [Help]

VIEW: HRI.HRI_TIME_DAY#

Source

View Text - Preformatted

select REPORT_DATE REPORT_DATE, REPORT_DATE_JULIAN REPORT_DATE_JULIAN, START_DATE START_DATE, END_DATE END_DATE, MONTH_ID MONTH_ID, ENT_PERIOD_ID ENT_PERIOD_ID, ENT_PERIOD_START_DATE ENT_PERIOD_START_DATE, ENT_QTR_ID ENT_QTR_ID, ENT_QTR_START_DATE ENT_QTR_START_DATE, ENT_YEAR_ID ENT_YEAR_ID, ENT_YEAR_START_DATE ENT_YEAR_START_DATE, WEEK_ID WEEK_ID, WEEK_START_DATE WEEK_START_DATE, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, WEEK_END_DATE WEEK_END_DATE, ENT_PERIOD_END_DATE ENT_PERIOD_END_DATE, ENT_QTR_END_DATE ENT_QTR_END_DATE, ENT_YEAR_END_DATE ENT_YEAR_END_DATE from "HRI"."HRI_TIME_DAY"
View Text - HTML Formatted

SELECT REPORT_DATE REPORT_DATE
, REPORT_DATE_JULIAN REPORT_DATE_JULIAN
, START_DATE START_DATE
, END_DATE END_DATE
, MONTH_ID MONTH_ID
, ENT_PERIOD_ID ENT_PERIOD_ID
, ENT_PERIOD_START_DATE ENT_PERIOD_START_DATE
, ENT_QTR_ID ENT_QTR_ID
, ENT_QTR_START_DATE ENT_QTR_START_DATE
, ENT_YEAR_ID ENT_YEAR_ID
, ENT_YEAR_START_DATE ENT_YEAR_START_DATE
, WEEK_ID WEEK_ID
, WEEK_START_DATE WEEK_START_DATE
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, WEEK_END_DATE WEEK_END_DATE
, ENT_PERIOD_END_DATE ENT_PERIOD_END_DATE
, ENT_QTR_END_DATE ENT_QTR_END_DATE
, ENT_YEAR_END_DATE ENT_YEAR_END_DATE
FROM "HRI"."HRI_TIME_DAY"