VIEW: APPS.MTH_445_PERIOD_CAL_HOUR_MV#

Source

View Text - Preformatted

select cal.day, cal.day_description, cal.day_end_date, cal.day_name, cal.day_of_fiscal_month,
       cal.day_of_fiscal_quarter, cal.day_of_fiscal_week, cal.day_of_fiscal_year,
       cal.day_start_date, cal.day_time_span, cal.dimension_key, cal.fis_month_number,
       cal.fis_quarter_number, cal.fis_week_number, cal.fis_year_number,
       cal.fiscal_month_description, cal.fiscal_month_end_date, cal.fiscal_month_name,
       cal.fiscal_month_start_date, cal.fiscal_month_time_span,
       cal.fiscal_quarter_description, cal.fiscal_quarter_end_date,
       cal.fiscal_quarter_name, cal.fiscal_quarter_start_date,
       cal.fiscal_quarter_time_span, cal.fiscal_week_description,
       cal.fiscal_week_end_date, cal.fiscaL_week_name,
       cal.fiscaL_week_start_date, cal.fiscal_week_time_span,
       cal.fiscal_year_description, cal.fiscal_year_end_date,
       cal.fiscaL_year_name, cal.fiscal_year_start_date,
       cal.fiscal_year_time_span, cal.julian_date,
       cal.month_of_fiscal_quarter, cal.month_of_fiscal_year,
       cal.quarter_of_fiscal_year, cal.week_of_fiscal_month,
       cal.week_of_fiscal_quarter, cal.week_of_fiscal_year,
       hour.HOUR_PK_KEY, HOUR.from_time,
       HOUR.to_time, HOUR.hour_pk, cal.ROWID crowid, HOUR.ROWID hrowid
from mth_445_Period_Calendar cal, mth_hour_d hour
where hour.from_time >= cal.DAY AND hour.from_time < cal.DAY + 1
AND cal.day is not NULL

View Text - HTML Formatted

SELECT CAL.DAY
, CAL.DAY_DESCRIPTION
, CAL.DAY_END_DATE
, CAL.DAY_NAME
, CAL.DAY_OF_FISCAL_MONTH
, CAL.DAY_OF_FISCAL_QUARTER
, CAL.DAY_OF_FISCAL_WEEK
, CAL.DAY_OF_FISCAL_YEAR
, CAL.DAY_START_DATE
, CAL.DAY_TIME_SPAN
, CAL.DIMENSION_KEY
, CAL.FIS_MONTH_NUMBER
, CAL.FIS_QUARTER_NUMBER
, CAL.FIS_WEEK_NUMBER
, CAL.FIS_YEAR_NUMBER
, CAL.FISCAL_MONTH_DESCRIPTION
, CAL.FISCAL_MONTH_END_DATE
, CAL.FISCAL_MONTH_NAME
, CAL.FISCAL_MONTH_START_DATE
, CAL.FISCAL_MONTH_TIME_SPAN
, CAL.FISCAL_QUARTER_DESCRIPTION
, CAL.FISCAL_QUARTER_END_DATE
, CAL.FISCAL_QUARTER_NAME
, CAL.FISCAL_QUARTER_START_DATE
, CAL.FISCAL_QUARTER_TIME_SPAN
, CAL.FISCAL_WEEK_DESCRIPTION
, CAL.FISCAL_WEEK_END_DATE
, CAL.FISCAL_WEEK_NAME
, CAL.FISCAL_WEEK_START_DATE
, CAL.FISCAL_WEEK_TIME_SPAN
, CAL.FISCAL_YEAR_DESCRIPTION
, CAL.FISCAL_YEAR_END_DATE
, CAL.FISCAL_YEAR_NAME
, CAL.FISCAL_YEAR_START_DATE
, CAL.FISCAL_YEAR_TIME_SPAN
, CAL.JULIAN_DATE
, CAL.MONTH_OF_FISCAL_QUARTER
, CAL.MONTH_OF_FISCAL_YEAR
, CAL.QUARTER_OF_FISCAL_YEAR
, CAL.WEEK_OF_FISCAL_MONTH
, CAL.WEEK_OF_FISCAL_QUARTER
, CAL.WEEK_OF_FISCAL_YEAR
, HOUR.HOUR_PK_KEY
, HOUR.FROM_TIME
, HOUR.TO_TIME
, HOUR.HOUR_PK
, CAL.ROWID CROWID
, HOUR.ROWID HROWID FROM MTH_445_PERIOD_CALENDAR CAL
, MTH_HOUR_D HOUR WHERE HOUR.FROM_TIME >= CAL.DAY
AND HOUR.FROM_TIME < CAL.DAY + 1 AND CAL.DAY IS NOT NULL