APPS.ISC_DEPOT_MTTR_ETL_PKG dependencies on ISC_DR_REPAIR_ORDERS_F

Line 81: ( p_fact_name => 'ISC_DR_REPAIR_ORDERS_F'

77: bis_collection_utilities.log( 'Truncated table ISC_DR_MTTR_F', 1 );
78:
79: l_stmt_id := 40;
80: if isc_depot_backlog_etl_pkg.get_last_run_date
81: ( p_fact_name => 'ISC_DR_REPAIR_ORDERS_F'
82: , x_run_date => l_run_date
83: , x_message => l_message
84: ) <> c_ok then
85: raise l_exception;

Line 135: , isc_dr_repair_orders_f bdr

131: , l_program_application_id
132: , l_request_id
133: from
134: csd_repair_types_b crt
135: , isc_dr_repair_orders_f bdr
136: , csd_product_transactions cpt
137: , cs_estimate_details ced
138: , poa_dbi_rtx_f pdr
139: , csd_product_transactions cpt1

Line 204: isc_dr_repair_orders_f bdr

200: , l_program_login_id
201: , l_program_application_id
202: , l_request_id
203: from
204: isc_dr_repair_orders_f bdr
205: , csd_repair_types_b crt
206: , csd_product_transactions cpt
207: , csd_product_transactions cpt1
208: , poa_dbi_rtx_f pdr

Line 272: isc_dr_repair_orders_f bdr

268: , l_program_login_id
269: , l_program_application_id
270: , l_request_id
271: from
272: isc_dr_repair_orders_f bdr
273: , csd_repair_types_b crt
274: , csd_product_transactions cpt
275: , csd_product_transactions cpt1
276: , poa_dbi_rtx_f pdr

Line 459: ( p_fact_name => 'ISC_DR_REPAIR_ORDERS_F'

455: bis_collection_utilities.log( 'MTTR From Date: ' || fnd_date.date_to_displaydt(l_run_date), 1 );
456:
457: l_stmt_id := 30;
458: if isc_depot_backlog_etl_pkg.get_last_run_date
459: ( p_fact_name => 'ISC_DR_REPAIR_ORDERS_F'
460: , x_run_date => l_last_run_date
461: , x_message => l_message
462: ) <> c_ok then
463: raise l_exception;

Line 488: isc_dr_repair_orders_f bdr

484: , min(pdr.transaction_date) repair_start_date
485: , max(ibs.actual_shipment_date) repair_end_date
486: , max(ibs.actual_shipment_date) - min(pdr.transaction_date) time_to_repair
487: from
488: isc_dr_repair_orders_f bdr
489: , csd_repair_types_b crt
490: , csd_product_transactions cpt
491: , csd_product_transactions cpt1
492: , cs_estimate_details ced

Line 579: isc_dr_repair_orders_f bdr

575: , min(pdr.transaction_date) repair_start_date
576: , max(ibs.actual_shipment_date) repair_end_date
577: , max(ibs.actual_shipment_date) - min(pdr.transaction_date) time_to_repair
578: from
579: isc_dr_repair_orders_f bdr
580: , csd_repair_types_b crt
581: , csd_product_transactions cpt
582: , csd_product_transactions cpt1
583: , poa_dbi_rtx_f pdr

Line 668: isc_dr_repair_orders_f bdr

664: , pdr.transaction_date repair_start_date
665: , ibs.actual_shipment_date repair_end_date
666: , ibs.actual_shipment_date - pdr.transaction_date time_to_repair
667: from
668: isc_dr_repair_orders_f bdr
669: , csd_repair_types_b crt
670: , csd_product_transactions cpt
671: , csd_product_transactions cpt1
672: , poa_dbi_rtx_f pdr