1808: cpt.revision,
1809: cpt.lot_number
1810: -- end 12.2 changes, subhat
1811: from
1812: csd_product_txns_v cpt,
1813: cs_incidents_all_b cib,
1814: csd_repairs cr,
1815: mtl_system_items_kfv mtl
1816: where cpt.repair_line_id = p_repair_line_id
3521: mtl.concatenated_segments item_name,
3522: cpt.revision,
3523: cpt.lot_number
3524: from
3525: csd_product_txns_v cpt,
3526: cs_incidents_all_b cib,
3527: csd_repairs cr,
3528: mtl_system_items_kfv mtl
3529: where cpt.repair_line_id = p_repair_line_id