APPS.CSI_ITEM_INSTANCE_PVT dependencies on CSD_PRODUCT_TXNS_V
Line 12252: (select 'X' from csd_product_txns_v cptv
12248: INTO l_number_open_ro
12249: FROM CSD_REPAIRS cr
12250: where cr.STATUS <> 'C'AND
12251: (cr.CUSTOMER_PRODUCT_ID = p_instance_rec.instance_id or exists 12252: (select 'X' from csd_product_txns_v cptv 12253: where cptv.repair_line_id = cr.repair_line_id and
12254: (cptv.source_instance_id = p_instance_rec.instance_id or
12255: cptv.non_source_instance_id = p_instance_rec.instance_id)));
12256: