APPS.CSI_ITEM_INSTANCE_PVT dependencies on CSD_REPAIRS
Line 12590: FROM CSD_REPAIRS cr
12586: IF p_txn_rec.transaction_type_id = 205
12587: THEN
12588: SELECT count(*)
12589: INTO l_number_open_ro 12590: FROM CSD_REPAIRS cr 12591: where cr.STATUS <> 'C'AND
12592: (cr.CUSTOMER_PRODUCT_ID = p_instance_rec.instance_id or exists
12593: (select 'X' from csd_product_txns_v cptv
12594: where cptv.repair_line_id = cr.repair_line_id and