APPS.CSD_PROCESS_PVT dependencies on CSD_REPAIR_TYPES_VL

Line 7356: FROM csd_repair_order_groups crog, csd_repair_types_vl crt

7352: CURSOR get_rep_group(p_incident_id IN NUMBER) IS
7353: SELECT crog.repair_group_id,
7354: crt.repair_type_ref,
7355: crog.group_txn_status
7356: FROM csd_repair_order_groups crog, csd_repair_types_vl crt
7357: WHERE crog.repair_type_id = crt.repair_type_id
7358: AND crog.incident_id = p_incident_id;
7359:
7360: CURSOR get_ro_order(p_repair_group_id IN NUMBER) IS

Line 9221: FROM csd_repairs dra, fnd_lookups fndl2, csd_repair_types_vl drtvl

9217: l_Inventory_Item_id,
9218: l_RO_Repair_Type_Ref,
9219: l_RO_Number,
9220: l_RO_Status_Meaning
9221: FROM csd_repairs dra, fnd_lookups fndl2, csd_repair_types_vl drtvl
9222: WHERE repair_line_id = p_Repair_line_id
9223: and dra.repair_type_id = drtvl.repair_type_id
9224: and dra.status = fndl2.lookup_code
9225: and fndl2.lookup_type = 'CSD_REPAIR_STATUS';