MATERIALIZED VIEW: APPS.PJI_TIME_PA_RPT_STR_MV

Source

select /* 12.0: bug#4526784 */
    rpt.CALENDAR_ID        CALENDAR_ID,
    'C'                  CALENDAR_TYPE,
    rpt.REPORT_DATE        REPORT_DATE,
    1                      PERIOD_TYPE_ID,
    4                      RECORD_TYPE_ID,
    day.REPORT_DATE_JULIAN TIME_ID
  from
    FII.FII_TIME_CAL_RPT_STRUCT rpt,
    FII.FII_TIME_DAY day,
    (
    select
      distinct
      cal.CALENDAR_ID
    from
      FII.FII_TIME_CAL_NAME      cal,
      GL.GL_LEDGERS       sob,
      PA.PA_IMPLEMENTATIONS_ALL pi
    where
      pi.SET_OF_BOOKS_ID  = sob.LEDGER_ID and
      sob.PERIOD_SET_NAME = cal.PERIOD_SET_NAME and
      pi.PA_PERIOD_TYPE   = cal.PERIOD_TYPE     and
      nvl(fnd_profile.value_wnps('PA_EN_NEW_GLDATE_DERIVATION'),'N')<>'Y'
    union
    select
      distinct
      cal.CALENDAR_ID
    from
      FII.FII_TIME_CAL_NAME cal,
      PA.PA_IMPLEMENTATIONS_ALL pi
    where
      pi.PERIOD_SET_NAME = cal.PERIOD_SET_NAME and
      pi.PA_PERIOD_TYPE  = cal.PERIOD_TYPE     and
      nvl(fnd_profile.value_wnps('PA_EN_NEW_GLDATE_DERIVATION'), 'N')='Y'
    ) cal
  where
    rpt.PERIOD_TYPE_ID = 16          and
    rpt.TIME_ID        = day.WEEK_ID and
    rpt.CALENDAR_ID    = cal.CALENDAR_ID