MATERIALIZED VIEW: APPS.MTH_SHIFT_GREGORIAN_DENORM_MV

Source

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