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

Source


SELECT /* 12.0: bug#4526784 */  its.carrier_id			CARRIER_ID, its.mode_of_transport		MODE_OF_TRANSPORT, its.service_level		SERVICE_LEVEL, grouping_id(service_level, carrier_id) AGG_LEVEL, grouping_id(its.carrier_id, its.mode_of_transport, its.service_level, cal.ent_qtr_id, cal.ent_period_id, cal.week_id, cal.report_date_julian) GRP_ID, decode(grouping_id(cal.ent_qtr_id, cal.ent_period_id, cal.week_id, cal.report_date_julian),        14,cal.report_date_julian,13,cal.week_id, 11,cal.ent_period_id,7,cal.ent_qtr_id) TIME_ID, decode(grouping_id(cal.ent_qtr_id,cal.ent_period_id,cal.week_id,cal.report_date_julian),	14,1,13,16,11,32,7,64) PERIOD_TYPE_ID, cal.report_date_julian		DAY_ID,  cal.week_id			WEEK_ID, cal.ent_period_id		ENT_PERIOD_ID, cal.ent_qtr_id			ENT_QTR_ID, sum(decode(its.stop_sequence_number, its.ultimate_stop_sequence_number, 1, 0))	TRIP_ARRIVALS, count(decode(its.stop_sequence_number, its.ultimate_stop_sequence_number, 1, 0))	TRIP_ARRIVALS_CNT, sum(case when (planned_arrival_date - actual_arrival_date) >= param.on_time_window/24 then 1 else 0 end) EARLY_STOP_ARRIVALS, count(case when (planned_arrival_date - actual_arrival_date) >= param.on_time_window/24 then 1 else 0 end) EARLY_STOP_ARRL_CNT, sum(case when (actual_arrival_date - planned_arrival_date) >= param.on_time_window/24 then 1 else 0 end) LATE_STOP_ARRIVALS, count(case when (actual_arrival_date - planned_arrival_date) >= param.on_time_window/24 then 1 else 0 end) LATE_STOP_ARRL_CNT, sum(case when abs(planned_arrival_date - actual_arrival_date) < param.on_time_window/24 then 1 else 0 end) ON_TIME_STOP_ARRIVALS, count(case when abs(planned_arrival_date - actual_arrival_date) < param.on_time_window/24 then 1 else 0 end) ON_TIME_STOP_ARRL_CNT, count(*) STOP_ARRIVALS FROM ISC.ISC_DBI_TRIP_STOPS_F its,      ISC.ISC_DBI_FTE_PARAMETERS param,      FII.FII_TIME_DAY cal WHERE its.time_actl_arrl_date_id = cal.report_date   AND its.time_pln_arrl_date_id is not null GROUP BY mode_of_transport, rollup(carrier_id), rollup(service_level), grouping sets(cal.ent_qtr_id, cal.ent_period_id, cal.week_id, cal.report_date_julian)