VIEW: APPS.HRI_TIME_CAL_DAY_MV#

Source

View Text - Preformatted

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_DATE_PERIOD_MAP  map    , GL_PERIODS          per    , HRI_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

View Text - HTML Formatted

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_DATE_PERIOD_MAP MAP
, GL_PERIODS PER
, HRI_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