APPS.ISC_MAINT_ASSET_DT_ETL_PKG dependencies on ISC_MAINT_ASSET_DOWN_F

Line 15: g_object_name constant varchar2(30) := 'ISC_MAINT_ASSET_DOWN_F';

11: g_error constant varchar2(10) := '-1';
12: g_warning constant varchar2(10) := '1';
13: g_bis_setup_exception exception;
14: g_global_start_date date;
15: g_object_name constant varchar2(30) := 'ISC_MAINT_ASSET_DOWN_F';
16: g_max_date constant date := to_date('4712/01/01','yyyy/mm/dd');
17: l_max_date constant date := to_date('4712/12/31','yyyy/mm/dd');
18:
19:

Line 170: ,'ISC_MAINT_ASSET_DOWN_F'

166: l_stmt_id := 30;
167:
168: if truncate_table
169: (l_biv_schema
170: ,'ISC_MAINT_ASSET_DOWN_F'
171: ,l_error_message ) <> 0 then
172: logger( l_proc_name, l_stmt_id, l_error_message );
173: raise l_exception;
174: end if;

Line 194: ISC_MAINT_ASSET_DOWN_F f

190: ------starts here------
191:
192:
193: Insert /*+ append parallel(f) */ into
194: ISC_MAINT_ASSET_DOWN_F f
195: (
196: asset_status_id
197: ,instance_id
198: ,asset_group_id

Line 444: merge into isc_maint_asset_down_f nbmaf

440: ----------------incremental load starts from here---------------
441:
442: /* removed the alternate query given by the performance team */
443:
444: merge into isc_maint_asset_down_f nbmaf
445: using
446: (
447: -- this inline view compares the new data set with the old data set and
448: -- only returns rows that have logically changed.

Line 473: -- by joining isc_maint_asset_down_f data to mtl_serial_numbers data

469: from
470: (
471: -- this inline view contains the current state of all enable_flag rows and
472: -- any rows that have become disabled since the last collection
473: -- by joining isc_maint_asset_down_f data to mtl_serial_numbers data
474: -- we also rename the maintenance_object_id to instance_id to remain consistent
475: -- with all the other regions
476: select
477: a.asset_status_id

Line 497: -- based only on isc_maint_asset_down_f

493: from
494: (
495: -- this inline view contains the current state of all enable_flag rows and
496: -- any rows that have become disabled since the last collection
497: -- based only on isc_maint_asset_down_f
498: select
499: asset_status_id
500: , maintenance_object_id
501: , asset_group_id

Line 639: , isc_maint_asset_down_f o

635: and a.maintenance_object_id = eomd.object_id(+) /* department is not mandatory */
636: and eomd.object_type(+)= 50 /* bug 4750689 */
637: and a.organization_id = eomd.organization_id(+)
638: ) n
639: , isc_maint_asset_down_f o
640: where
641: n.asset_status_id = o.asset_status_id(+)
642: and ( o.asset_status_id is null or
643: n.category_id <> o.category_id or