APPS.ISC_MAINT_REQ_WO_ETL_PKG dependencies on ISC_MAINT_REQ_WO_STG

Line 515: , 'ISC_MAINT_REQ_WO_STG'

511: -- truncate the staging table
512: l_stmt_id := 30;
513: if truncate_table
514: ( l_isc_schema
515: , 'ISC_MAINT_REQ_WO_STG'
516: , l_error_message ) <> 0 then
517: logger( l_proc_name, l_stmt_id, l_error_message );
518: raise l_exception;
519: end if;

Line 526: isc_maint_req_wo_stg

522:
523: -- this detects all SR with changed associations
524: l_stmt_id := 40;
525: insert into
526: isc_maint_req_wo_stg
527: ( maint_request_id
528: , phase_id
529: , creation_date
530: , created_by

Line 561: isc_maint_req_wo_stg s

557:
558: -- this detects all SR where associated WO is updated
559: l_stmt_id := 50;
560: merge into
561: isc_maint_req_wo_stg s
562: using
563: ( select distinct
564: service_request_id maint_request_id
565: , 2 phase_id

Line 624: isc_maint_req_wo_stg s

620: -- a change at the association level.
621:
622: l_stmt_id := 60;
623: merge into
624: isc_maint_req_wo_stg s
625: using
626: ( select distinct
627: incident_id maint_request_id
628: , 3 phase_id

Line 694: , 'ISC_MAINT_REQ_WO_STG'

690: -- gather statistics on staging table
691: l_stmt_id := 70;
692: if gather_statistics
693: ( l_isc_schema
694: , 'ISC_MAINT_REQ_WO_STG'
695: , l_error_message ) <> 0 then
696: logger( l_proc_name, l_stmt_id, l_error_message );
697: raise l_exception;
698: end if;

Line 842: , isc_maint_req_wo_stg c

838: from
839: cs_incidents_all_b i
840: , eam_wo_service_association a
841: , isc_maint_work_orders_f w
842: , isc_maint_req_wo_stg c
843: where
844: i.incident_id = a.service_request_id
845: and a.wip_entity_id = w.work_order_id
846: and a.maintenance_organization_id = w.organization_id

Line 989: , 'ISC_MAINT_REQ_WO_STG'

985: -- housekeeping/cleanup truncate the staging table
986: l_stmt_id := 90;
987: if truncate_table
988: ( l_isc_schema
989: , 'ISC_MAINT_REQ_WO_STG'
990: , l_error_message ) <> 0 then
991: logger( l_proc_name, l_stmt_id, l_error_message );
992: raise l_exception;
993: end if;