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.BIL_BI_CAL_MV

Source


(
(
SELECT /*+ NO_MERGE NO_PARALLEL */  
  time_id, 
  period_type_id,
  report_date,
  record_type_id,
  FLAG ,
  NULL week_id,
  NULL ent_period_id,
  NULL ent_qtr_id,
  NULL ent_year_id,
  NULL credit_type_id
FROM (
 SELECT /*+ NO_PARALLEL(cal) */  
  cal.time_id, 
  cal.period_type_id,
  cal.report_date,
  cal.record_type_id,
  DECODE(cal.report_date, 
      FII_TIME_API.ent_sd_lysqtr_end(TRUNC(SYSDATE)), 'SD_LYRSQ',       
	   FII_TIME_API.ent_sd_pqtr_end( TRUNC(SYSDATE)), 'SD_SYRPQ'
	 ) FLAG
 FROM 
  fii_time_structures cal
 WHERE
  cal.report_date IN
   (
    FII_TIME_API.ent_sd_lysqtr_end(TRUNC(SYSDATE)),
    FII_TIME_API.ent_sd_pqtr_end(TRUNC(SYSDATE))
   )
  AND cal.xtd_flag = 'Y'
  AND BITAND(cal.record_type_id, 128) = 128 
UNION ALL 
  SELECT /*+ NO_PARALLEL(cal) */ 
  cal.time_id, 
  cal.period_type_id,
  cal.report_date,
  cal.record_type_id,
  DECODE(cal.report_date, 
      FII_TIME_API.ent_sd_lysper_end(TRUNC(SYSDATE)), 'SD_LYRSP',       
      FII_TIME_API.ent_sd_pper_end(TRUNC(SYSDATE)),'SD_SYRPP'
	 ) FLAG
 FROM 
  fii_time_structures cal 
 WHERE
  cal.report_date IN
   (
    FII_TIME_API.ent_sd_lysper_end(TRUNC(SYSDATE)),
    FII_TIME_API.ent_sd_pper_end(TRUNC(SYSDATE))
   )
  AND cal.xtd_flag = 'Y'
  AND BITAND(cal.record_type_id, 64) = 64
UNION ALL 
  SELECT /*+ NO_PARALLEL(cal) */ 
  cal.time_id, 
  cal.period_type_id,
  cal.report_date,
  cal.record_type_id,
  DECODE(cal.report_date, 
      FII_TIME_API.sd_lyswk(TRUNC(SYSDATE)), 'SD_LYRSW',       
	   FII_TIME_API.sd_pwk(TRUNC(SYSDATE)), 'SD_SYRPW'
	 ) FLAG
 FROM 
  fii_time_structures cal 
 WHERE
  cal.report_date IN
   (
    FII_TIME_API.sd_lyswk(TRUNC(SYSDATE)), 
    FII_TIME_API.sd_pwk(TRUNC(SYSDATE)) 
   )
  AND cal.xtd_flag = 'Y'
  AND BITAND(cal.record_type_id, 32) = 32
UNION ALL 
  SELECT /*+ NO_PARALLEL(cal) */ 
  cal.time_id, 
  cal.period_type_id,
  cal.report_date,
  cal.record_type_id,
  DECODE(cal.report_date, 
	     FII_TIME_API.ent_sd_lyr_end(TRUNC(SYSDATE)), 'SD_LYR'
	   ) FLAG
 FROM 
  fii_time_structures cal 
 WHERE
  cal.report_date = FII_TIME_API.ent_sd_lyr_end(TRUNC(SYSDATE)) 
  AND cal.xtd_flag = 'Y'
  AND BITAND(cal.record_type_id, 256) = 256
UNION ALL 
  SELECT /*+ NO_PARALLEL(cal) */ 
  cal.time_id, 
  cal.period_type_id,
  cal.report_date,
  cal.record_type_id,
  DECODE(cal.report_date, TRUNC(SYSDATE), 'SD_SYR' ) FLAG
 FROM 
  fii_time_structures cal 
 WHERE
  cal.report_date =  TRUNC(SYSDATE) 
  AND cal.xtd_flag = 'Y'
  AND 
    (BITAND(cal.record_type_id, 256) = 256 OR
    BITAND(cal.record_type_id, 128) = 128 OR
    BITAND(cal.record_type_id, 64) = 64 OR
    BITAND(cal.record_type_id, 32) = 32 
    )
)
)
UNION ALL 
(
SELECT /*+ NO_MERGE NO_PARALLEL */  
  time_id, 
  period_type_id,
  report_date,
  record_type_id,
  flag,
  week_id,
  ent_period_id,
  ent_qtr_id,
  ent_year_id,
  FND_PROFILE.Value('ASN_FRCST_CREDIT_TYPE_ID') credit_type_id
FROM (
 SELECT /*+ NO_PARALLEL(cal) */ 
  cal.time_id, 
  cal.period_type_id,
  cal.report_date,
  cal.record_type_id,
  DECODE(cal.report_date, 
      FII_TIME_API.ent_sd_lysqtr_end(TRUNC(SYSDATE)), 'FST_SD_LYRSQ',       
	   FII_TIME_API.ent_sd_pqtr_end(TRUNC(SYSDATE)), 'FST_SD_SYRPQ'
	 ) FLAG,
  day1.week_id,
  day1.ent_period_id,
  day1.ent_qtr_id,
  day1.ent_year_id
 FROM 
  fii_time_structures cal,
  fii_time_day day1 
 WHERE
  cal.report_date IN
   (
    FII_TIME_API.ent_sd_lysqtr_end(TRUNC(SYSDATE)),
    FII_TIME_API.ent_sd_pqtr_end(TRUNC(SYSDATE))
   )
  AND cal.xtd_flag = 'Y'
  AND BITAND(cal.record_type_id, 512) = 512
  AND day1.report_date = cal.report_date
UNION ALL 
  SELECT /*+ NO_PARALLEL(cal) */ 
  cal.time_id, 
  cal.period_type_id,
  cal.report_date,
  cal.record_type_id,
  DECODE(cal.report_date, 
      FII_TIME_API.ent_sd_lysper_end(TRUNC(SYSDATE)), 'FST_SD_LYRSP',       
      FII_TIME_API.ent_sd_pper_end(TRUNC(SYSDATE)),'FST_SD_SYRPP'
	 ) FLAG,
  day1.week_id,
  day1.ent_period_id,
  day1.ent_qtr_id,
  day1.ent_year_id
 FROM 
  fii_time_structures cal, 
  fii_time_day day1 
 WHERE
  cal.report_date IN
   (
    FII_TIME_API.ent_sd_lysper_end(TRUNC(SYSDATE)),
    FII_TIME_API.ent_sd_pper_end(TRUNC(SYSDATE))
   )
  AND cal.xtd_flag = 'Y'
  AND BITAND(cal.record_type_id, 512) = 512
  AND day1.report_date = cal.report_date
UNION ALL 
  SELECT /*+ NO_PARALLEL(cal) */ 
  cal.time_id, 
  cal.period_type_id,
  cal.report_date,
  cal.record_type_id,
  DECODE(cal.report_date, 
      FII_TIME_API.sd_lyswk(TRUNC(SYSDATE)), 'FST_SD_LYRSW',       
	   FII_TIME_API.sd_pwk(TRUNC(SYSDATE)), 'FST_SD_SYRPW'
	 ) FLAG,
  day1.week_id,
  day1.ent_period_id,
  day1.ent_qtr_id,
  day1.ent_year_id
 FROM 
  fii_time_structures cal, 
  fii_time_day day1 
 WHERE
  cal.report_date IN
   (
    FII_TIME_API.sd_lyswk(TRUNC(SYSDATE)), 
    FII_TIME_API.sd_pwk(TRUNC(SYSDATE)) 
   )
  AND cal.xtd_flag = 'Y'
  AND BITAND(cal.record_type_id, 512) = 512
  AND day1.report_date = cal.report_date
UNION ALL 
  SELECT /*+ NO_PARALLEL(cal) */ 
  cal.time_id, 
  cal.period_type_id,
  cal.report_date,
  cal.record_type_id,
  DECODE(cal.report_date, 
	     FII_TIME_API.ent_sd_lyr_end(TRUNC(SYSDATE)), 'FST_SD_LYR'
	   ) FLAG,
  day1.week_id,
  day1.ent_period_id,
  day1.ent_qtr_id,
  day1.ent_year_id
 FROM 
  fii_time_structures cal ,
  fii_time_day day1 
 WHERE
  cal.report_date = FII_TIME_API.ent_sd_lyr_end(TRUNC(SYSDATE)) 
  AND cal.xtd_flag = 'Y'
  AND BITAND(cal.record_type_id, 512) = 512
  AND day1.report_date = cal.report_date
UNION ALL 
  SELECT /*+ NO_PARALLEL(cal) */ 
  cal.time_id, 
  cal.period_type_id,
  cal.report_date,
  cal.record_type_id,
  DECODE(cal.report_date, TRUNC(SYSDATE), 'FST_SD_SYR' ) FLAG,
  day1.week_id,
  day1.ent_period_id,
  day1.ent_qtr_id,
  day1.ent_year_id
 FROM 
  fii_time_structures cal, 
  fii_time_day day1 
 WHERE
  cal.report_date =  TRUNC(SYSDATE)
  AND cal.xtd_flag = 'Y'
  AND BITAND(cal.record_type_id, 512) = 512     
  AND day1.report_date = cal.report_date
)
)
)