eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

MATERIALIZED VIEW: APPS.FII_TIME_CAL_DAY_MV

Source


SELECT  /* 12.0: bug#4526784 */  TRUNC(map.accounting_date)                              REPORT_DATE    , TO_NUMBER(TO_CHAR(map.accounting_date,'J'))           REPORT_DATE_JULIAN    , cal.calendar_id                                       CALENDAR_ID    , to_number(        cal.calendar_id||        per.period_year||        per.quarter_num||        lpad(per.period_num, 2, '0') )                      CAL_PERIOD_ID    , per.start_date                                        CAL_PERIOD_START_DATE    , to_number(        cal.calendar_id||        per.period_year||        per.quarter_num)                                    CAL_QTR_ID    , per.quarter_start_date                                CAL_QTR_START_DATE    , to_number(        cal.calendar_id||        per.period_year)                                    CAL_YEAR_ID    , per.year_start_date                                   CAL_YEAR_START_DATE    , SYSDATE                                               CREATION_DATE    , SYSDATE                                               LAST_UPDATE_DATE    FROM    GL.GL_DATE_PERIOD_MAP  map    , GL.GL_PERIODS          per    , FII.FII_TIME_CAL_NAME   cal    WHERE map.period_set_name = cal.period_set_name    AND map.period_type = cal.period_type    AND map.period_set_name = per.period_set_name    AND map.period_name = per.period_name