APPS.CSI_ITEM_INSTANCE_PVT dependencies on CSD_REPAIRS
Line 12249: FROM CSD_REPAIRS cr
12245: IF p_txn_rec.transaction_type_id = 205
12246: THEN
12247: SELECT count(*)
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