APPS.ISC_DEPOT_MTTR_ETL_PKG dependencies on CS_ESTIMATE_DETAILS

Line 137: , cs_estimate_details ced

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
140: , cs_estimate_details ced1
141: , isc_book_sum2_f ibs

Line 140: , cs_estimate_details ced1

136: , csd_product_transactions cpt
137: , cs_estimate_details ced
138: , poa_dbi_rtx_f pdr
139: , csd_product_transactions cpt1
140: , cs_estimate_details ced1
141: , isc_book_sum2_f ibs
142: where
143: bdr.repair_line_id = cpt.repair_line_id
144: and bdr.repair_type_id = crt.repair_type_id

Line 492: , cs_estimate_details ced

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
493: , cs_estimate_details ced1
494: , poa_dbi_rtx_f pdr
495: , isc_book_sum2_f ibs
496: where

Line 493: , cs_estimate_details ced1

489: , csd_repair_types_b crt
490: , csd_product_transactions cpt
491: , csd_product_transactions cpt1
492: , cs_estimate_details ced
493: , cs_estimate_details ced1
494: , poa_dbi_rtx_f pdr
495: , isc_book_sum2_f ibs
496: where
497: bdr.repair_line_id = cpt.repair_line_id

Line 821: -- corresponding to the line id stamped on the cs_estimate_details is alone

817: -- action types, this being the case these lines have to be uncommented.
818:
819: -- For Non-refurbishment repair type, if shipment of items is done by spliting
820: -- the line id manually in Order Management form then the max of shipment date
821: -- corresponding to the line id stamped on the cs_estimate_details is alone
822: -- taken. The shipment date on the split line ids are not taken into
823: -- consideration. This requires a 'Connect By' to be included in the query
824: -- which may cause performance issues.
825: