DBA Data[Home] [Help]

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