APPS.ISC_MAINT_WO_BACKLOG_RPT_PKG dependencies on ISC_MAINT_WORK_ORDERS_F

Line 136: from isc_maint_work_orders_f f,

132: , status.value status_name
133: , work_order_type
134: , SCHEDULED_COMPLETION_DATE
135: , SCHEDULED_START_DATE
136: from isc_maint_work_orders_f f,
137: biv_maint_wo_status_lvl_v status
138: where
139: f.user_defined_status_id = status.id
140: and status_type not in (12, 14, 15, 4, 5, 7) /* Not in: Closed, Pending Close, Failed Close, Complete, Complete - No Charges, Cancelled */

Line 184: from isc_maint_work_orders_f f,

180: when (trunc(coll.last_update_date)- f.scheduled_completion_date) >= b.range8_high and ((trunc(coll.last_update_date)- f.scheduled_completion_date) < b.range9_high or b.range9_high is null) then 9
181: when (trunc(coll.last_update_date)- f.scheduled_completion_date) >= b.range9_high and ((trunc(coll.last_update_date)- f.scheduled_completion_date) < b.range10_high or b.range10_high is null) then 10
182: else 0
183: end bucket_num
184: from isc_maint_work_orders_f f,
185: isc_maint_work_orders_f coll,
186: bis_bucket_customizations b,
187: bis_bucket bb,
188: biv_maint_wo_status_lvl_v status

Line 185: isc_maint_work_orders_f coll,

181: when (trunc(coll.last_update_date)- f.scheduled_completion_date) >= b.range9_high and ((trunc(coll.last_update_date)- f.scheduled_completion_date) < b.range10_high or b.range10_high is null) then 10
182: else 0
183: end bucket_num
184: from isc_maint_work_orders_f f,
185: isc_maint_work_orders_f coll,
186: bis_bucket_customizations b,
187: bis_bucket bb,
188: biv_maint_wo_status_lvl_v status
189: where

Line 307: select nvl(max(trunc(last_update_date)),trunc(l_as_of_date)-1) into l_last_collection_date from isc_maint_work_orders_f coll

303:
304:
305:
306: l_as_of_date:= to_date(isc_maint_rpt_util_pkg.get_parameter_value(p_param, 'AS_OF_DATE'),'DD/MM/YYYY');
307: select nvl(max(trunc(last_update_date)),trunc(l_as_of_date)-1) into l_last_collection_date from isc_maint_work_orders_f coll
308: where coll.Organization_id = -99 and coll.Work_Order_id = -99 and coll.Entity_Type = -1;
309:
310: case
311: when l_as_of_date >= l_last_collection_date then