DBA Data[Home] [Help]

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