VIEW: APPS.MTH_SHIFT_GREGORIAN_DENORM_MV#

Source

View Text - Preformatted

select  ws.shift_workday_pk_key, ws.shift_date, ws.plant_fk_key, ws.system_fk_key,ws.from_date,
  ws.To_Date, gc.day_id, gc.calendar_month_id, gc.calendar_quarter_id, gc.calendar_year_id, gc.CALENDAR_MONTH_START_DATE,
  gc.CALENDAR_QUARTER_START_DATE, gc.CALENDAR_YEAR_START_DATE, ws.ROWID rowid_ws, gc.ROWID rowid_gc
     FROM  MTH_WORKDAY_SHIFTS_D ws, MTH_GREGORIAN_CALENDAR gc
     where ws.SHIFT_DATE = gc.DAY
           AND gc.DAY IS NOT NULL  

View Text - HTML Formatted

SELECT WS.SHIFT_WORKDAY_PK_KEY
, WS.SHIFT_DATE
, WS.PLANT_FK_KEY
, WS.SYSTEM_FK_KEY
, WS.FROM_DATE
, WS.TO_DATE
, GC.DAY_ID
, GC.CALENDAR_MONTH_ID
, GC.CALENDAR_QUARTER_ID
, GC.CALENDAR_YEAR_ID
, GC.CALENDAR_MONTH_START_DATE
, GC.CALENDAR_QUARTER_START_DATE
, GC.CALENDAR_YEAR_START_DATE
, WS.ROWID ROWID_WS
, GC.ROWID ROWID_GC
FROM MTH_WORKDAY_SHIFTS_D WS
, MTH_GREGORIAN_CALENDAR GC
WHERE WS.SHIFT_DATE = GC.DAY
AND GC.DAY IS NOT NULL