APPS.ISC_DEPOT_MTTR_ETL_PKG dependencies on CSD_PRODUCT_TRANSACTIONS

Line 136: , csd_product_transactions cpt

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

Line 139: , csd_product_transactions cpt1

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
142: where
143: bdr.repair_line_id = cpt.repair_line_id

Line 206: , csd_product_transactions cpt

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
209: , isc_book_sum2_f ibs
210: where

Line 207: , csd_product_transactions cpt1

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
209: , isc_book_sum2_f ibs
210: where
211: bdr.repair_line_id = cpt.repair_line_id

Line 274: , csd_product_transactions cpt

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
277: , mtl_unit_transactions mut
278: , isc_book_sum2_f ibs

Line 275: , csd_product_transactions cpt1

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
277: , mtl_unit_transactions mut
278: , isc_book_sum2_f ibs
279: where

Line 490: , csd_product_transactions cpt

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
493: , cs_estimate_details ced1
494: , poa_dbi_rtx_f pdr

Line 491: , csd_product_transactions cpt1

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

Line 581: , csd_product_transactions cpt

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
584: , isc_book_sum2_f ibs
585: where

Line 582: , csd_product_transactions cpt1

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
584: , isc_book_sum2_f ibs
585: where
586: bdr.repair_line_id = cpt.repair_line_id

Line 670: , csd_product_transactions cpt

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
673: , mtl_unit_transactions mut
674: , isc_book_sum2_f ibs

Line 671: , csd_product_transactions cpt1

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
673: , mtl_unit_transactions mut
674: , isc_book_sum2_f ibs
675: where